Text to Columns

This activity helps the user to insert columns with the text specified from the chosen data range in the excel sheet. It must be used within the “Excel Scope” activity.

Properties

Input

Sheet Name*: Indicates to provide the “SheetName” to insert the data, and it accepts values in the “String” datatype.”

Source Range*: Specifies to provide the source range from where the text needs to be retrieved and it accepts values in “String” datatype.

Destination*: Specifies to provide the destination column range where the text needs to be inserted and it accepts values in “String” datatype.

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

Options

Delimiter Options

Comma: Splits the text into columns wherever a comma ( , ) is found.

Semi Colon: Splits the text into columns wherever a semicolon ( ; ) is found.

Space: Splits the text into columns wherever a space character occurs.

Tab: Splits the text into columns wherever a tab character is present.

Line Break: Splits the text into columns at each line break (new line) in the text.

Other: Allows users to specify a custom delimiter character not listed in the default options.

Other Delimiter: Specifies the custom character to be used as the delimiter when the Other option is selected.

Consecutive Operator as One: When enabled, treat multiple consecutive delimiters as a single delimiter during the split operation.
Note: You can use this option when your data has inconsistent spacing, empty columns or extra delimiters.

Data Type: Specifies to choose the option on how the text should be split into columns.

• Delimited: Splits text based on the selected delimiter(s).

• Fixed Width: Splits text based on a fixed number of characters per column.

Number of Characters per Column: Specifies the number of characters to be used for each column when Fixed Width is selected. This option is applicable only for the Fixed Width data type.

Text Qualifier: Specifies a character that encloses text values. Text within the qualifier is treated as a single value even if it contains delimiters.

• None: No text qualifier is applied.

• Double Quote ( ” ): Treats text enclosed in double quotes as a single value.

• Single Quote ( ‘ ): Treats text enclosed in single quotes as a single value.

OUTPUT

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow