Text to Columns

The Text to Columns action splits a column into multiple columns in an Excel workbook. When run, the action takes the text from an Excel cell and converts the text into a column.

Note: The Actions Quick Reference provides a complete list of actions that you can print for easy reference.

Create a Text to Columns action

  1. Drag the Target Selector from the Build Pane Area to add new actions and edit existing actions. The Build Pane displays after you select a targeted element in a Windows application. The center of the Build Pane is referred to as the Task Editor Pane. and drop it onto the Excel cell that contains the text with separators that needs to be split into columns. The separators (delimiters) can be any text value.

  2. Select Text to Columns.

  3. Select the Delimiters that you want to use:

    • Comma

    • Semicolon

    • Space

    • Tab

    • Other. If you select Other, click the Magic Wand to use the Expression Builder and create a custom delimiter.

  4. (Optional) Select Treat consecutive delimiters as one to treat multiple delimiters that appear in sequence as one single delimiter and ignore the fields between them.

    For example, If cell A1 contains A, B,, C (A comma space space B comma comma B space space space C) and you do not select this option, each comma and each space is treated as an independent split point: Col1 = A, Col2 = blank, Col3 = blank, Col4 = B, Col5 = blank, Col6 = C

    If you do select this option, each of the three columns will contain a letter: Col1 = A, Col2 = B, Col3 = C

  5. Click Rules to modify how Nintex Bot finds the target.

  6. If needed, adjust the Timing settings to fine tune how the action runs.

  7. If needed, adjust the Run error task settings to fine tune how the action runs.

    • Run error task: A botflow containing an error task automatically runs the error task in the event of an error. If the botflow does not contain an error task, the botflow stops in the event of an error.
    • Stop on error: The botflow stops in the event of an error.
    • Ignore errors: The action is skipped in the event of an error and the botflow attempts to execute the next action.

  8. (Optional) Add a Note to document special instructions or functionality.

  9. Toggle the run switch to Run and click OK to execute and save the action.

    10. Note: The run switch is set to Run by default. To create or modify this action without executing it, click the slider to change the option to Don't Run. For more information, go to Action Builder.