Split Text Step

The Split Text step separates a column into several distinct columns based on a separator character. Use it when the content of a single column needs to be segmented into separate columns, which facilitates data organization and visualization.

How to configure

Fill in the fields below:

• Column To Split: defines the column to be split, from the list of all valid alphanumeric columns in the sample.

• Delimiter: selects the character used as a parameter for the split.

• Number of Columns: defines how many new columns will be created. The default value is 2 and can reach 100.

• New Column Name: defines the name pattern for the created columns, with a 100-character limit. The default is "New Column" and is replicated to the other columns, followed by the numbering of each, according to the Number of Columns.

• Extra Characters: decides what to do with the characters remaining after the split.

The Delimiter options are:

• Single Quotes ( ' ).

• Double Quotes ( " ).

• Space.

• Pipe ( | ).

• Dot ( . ).

• Semicolon ( ; ).

• Comma ( , ).

• Other: displays a text field to define any character as a delimiter.

The Extra Characters options are:

• Ignore excess characters (default option).

• Keep excess characters in the last column.