REMOVE_WHITESPACE
Removes white space from the strings in the source column or custom strings, and returns the result in a new column.
Parameters
-
sourceColumn
– The name of an existing column. -
value
– A character string to evaluate. -
targetColumn
– The name of the new column to be created.
Note
You can specify either sourceColumn
or value
, but not
both.
Examples
{ "RecipeAction": { "Operation": "REMOVE_WHITESPACE", "Parameters": { "sourceColumn": "job_desc", "targetColumn": "job_desc_remove_whitespace" } } }
{ "RecipeAction": { "Operation": "REMOVE_WHITESPACE", "Parameters": { "value": "This string has spaces in it", "targetColumn": "string_without_spaces" } } }