Table Split Text

Description

The Table: Split Text step splits the text in one column at a separator and writes the pieces as new columns or as new rows. The number of columns is decided when the step runs, from the value with the most pieces, so you don’t need to know it in advance.

Source & Options

• Source Table and Output Table — the table to read and the table to write.
• Column to split — the column to split. A number is split as its text.
• Separator — the literal text between pieces. It can be any length and is not a pattern. Spaces are kept as typed.
• Split into — Columns or Rows.
  • Columns writes <column>_1, <column>_2, and so on, as many as the value with the most pieces. A value with fewer pieces gets NULL in the rest.
  • Rows writes one row per piece, with the piece in place of the column. Empty pieces stay as rows.
• Trim spaces around each piece — on by default.
• Keep the original column — on by default. In columns mode it keeps the split column. In rows mode it also writes the unsplit value to <column>_original.

An empty result replaces the output table. It never leaves rows from an earlier run.

Related

• Table Extract — the split_part expression, for a fixed number of columns
• Migrate Savant Analyses