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