Split column

This processor splits a column on each occurence of the delimiter.

Output

This processor creates a new column for each splitted chunk. You can specify a prefix for output columns. Output columns will be numbered : the first chunk will be in prefix_0, the second in prefix_1, and so on.

Truncation

You can limit the number of columns that this processor produces by checking the Truncate option. You can choose to keep only the first N columns or only the last N columns

Examples

  • Delimiter: ‘/’ - prefix : ‘ocol’, Keep 2 columns, from beginning
  • input = ‘a/b/c’, output will be : ocol_0=a ocol_1=b
  • input = ‘a’, output will be : ocol_0=a
  • Delimiter : ‘/’ - prefix : ‘ocol’, Keep 2 columns, from end
  • input = ‘a/b/c’, output will be : ocol_0=c ocol_1=b
  • input = ‘a’, output will be : ocol_0=a