Text to Columns

UiPath.Excel.Activities.Business.TextToColumnsX

Splits the text from a cell, range, or table into different columns. The activity can be used with an Excel file selected for a parent Use Excel File activity or with the Project Notebook.

Configuring the Activity

In the Body of the Activity

• Source - Click Plus on the right side of the field, and then, from the menu, select Indicate in Excel to indicate the column that contains the text to split. Alternatively, you can select Custom Input to enter a range or table name manually, or Open in Advanced Editor to enter a VB expression.
• Destination - Click Plus on the right side of the field, and then, from the menu, select the sheet or the table where you want the split data to appear, or select Indicate in Excel to indicate directly from the file. Alternatively, you can select Custom Input to enter a range, table name, or sheet name manually, or Open in Advanced Editor to enter a VB expression.

• Data type - Select the data type from the drop-down menu, Delimited (the data is separated by certain characters) or Fixed width (the data is separated in groups of a certain number of characters).

  • For Delimited, configure the following:

    • Delimiter - Select the characters that separate the data: Tab, Semicolon, Comma, Space, Line Break, or Other. By default, all the options except Line Break and Other are selected.

      If you select Other, enter a value in the Other delimiter field.

    • Consecutive operators as one - If selected, it indicates the data contains delimiters with multiple characters. This option is selected by default.
    • Text qualifier - Select the character that encloses text in your data. Text between two consecutive text qualifiers is treated as one value. The options in the drop-down menu are None (the default selection), Single quote, and Double quote.
  • For Fixed width, click Plus on the right side of the Number of characters per column field, and then, from the menu, select Number and enter the number of characters. Alternatively, you can indicate a cell in Excel or select Open in Advanced Editor and enter a VB expression.

Properties Panel

Common

• DisplayName - The name displayed for the activity in the Designer panel.

Input

• Destination - See Destination in the body of the activity.
• Source range - See Source in the body of the activity.

Misc

• Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Options

• See the options for Data type in the body of the activity.