Text to Columns tool icon

Text to Columns Tool

Last modified: September 09, 2021

One Tool Example

Text to Columns has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer Cloud.

Docs are available before the release of Designer Cloud so you can get a sneak peek. This content might change between now and the official release.

Use Text To Columns to take the text in 1 column and split the string value into multiple separate columns or rows, based on a 1 or more delimiters.

Configure the Tool

  1. Select the Column to Split.
  2. Delimiters: Enter the delimiters you want to use to split the data. Each character is treated independently, meaning you can't delimit on a word. To split data on a word, use the RegEx tool. You can use individual characters or the white space characters from this table:
    White Space White Space Character
    Tab \t
    New Line \n
    Space \s
    Space or Tab \s\t
  3.  Choose the split method:
    • Split into Columns: Split a single column of data at each instance of the specified delimiter into multiple columns.
      • Number of Output Columns: Choose how many columns to create.
      • Output Column Header: Enter the name for the newly generated columns. The new columns are named as the root name with a serially increasing integer appended.
      • Extra Characters: Choose what you want to do with any extra characters.
        • Leave in Last Column: Data that extends past the split is appended to the value in the last column.
        • Drop with Warning: Data that extends past the split is dropped and a warning is generated indicating that there is excess information.
        • Drop without Warning: Data that extends past the split is dropped and no warning is generated.
        • Error: Data that extends past the split causes an error and the workflow stops processing.
    • Split into Rows: Split a single column of data at each instance of the specified delimiter into multiple rows. Use a key column in your row so you don't lose track of what value comes from what row.
  4. In Advanced Options, select delimiters to ignore:
    • Ignore Delimiters in Quotes
    • Ignore Delimiters in Single Quotes
    • Ignore Delimiters in Parentheses
    • Ignore Delimiters in Brackets
    • Skip Empty Columns
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.