UiPath.Excel.Activities.Business.TextToColumnsX
Splits the text from a cell, range, or table into different columns.
In the Body of the Activity
- Source range - Click
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 range - Click 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, Other. By default, all the options are selected. If Other is selected, click on the right side of the Other delimiter field, and then indicate in Excel a cell that contains a delimiter, or select Open in Advanced Editor and enter a VB expression.
- 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 on the right side of the Number of characters per column field, and then, from the menu, select Number, and then 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
Common
- Display Name - The name displayed for the activity in the Designer panel.
Input
- Destination Range - See Destination range in the body of the activity.
- Source Range - See Source range in the body of the activity.
Misc
- Private - If selected, the data used in the activity is not logged by StudioX.
Options
- See the options for Data type in the body of the activity.
Updated 3 years ago