SPLIT_COLUMN_BETWEEN_POSITIONS
Splits a column into three new columns, according to offsets that you specify.
Parameters
-
sourceColumn
– The name of an existing column. -
startPosition
– The character position where the split is to begin. -
endPosition
– The character position where the split is to end.
Example
{
"RecipeAction": {
"Operation": "SPLIT_COLUMN_BETWEEN_POSITIONS",
"Parameters": {
"endPosition": "12",
"sourceColumn": "last_name",
"startPosition": "2"
}
}
}