UiPath Activities

The UiPath Activities Guide

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 range - Click Plus plus button 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 Plus plus button 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 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 plus button 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.

In the Properties Panel

Common

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

Input

Misc

  • Private - If selected, the data used in the activity is not logged by StudioX.

Options

Updated about 15 hours ago


Text to Columns


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.