EXTRACT_PATTERN
Creates a new column, based on a regular expression, from the values in an existing column.
Parameters
-
sourceColumn– The name of an existing column. -
targetColumn– The name of the new column to be created. -
pattern– A regular expression that indicates which character or characters to extract and create the new column from.
Example
{
"RecipeAction": {
"Operation": "EXTRACT_PATTERN",
"Parameters": {
"pattern": "^....*...$",
"sourceColumn": "last_name",
"targetColumn": "first_and_last_few_characters"
}
}
}