FIND
Searching left to right, finds strings that match a specified string from the source column or from a custom value, and returns the result in a new column.
Parameters
-
sourceColumn– The name of an existing column. -
pattern– A regular expression to search for. -
position– The character position to begin with, from the left end of the string. -
ignoreCase– Iftrue, ignore differences of case (between uppercase and lowercase) among letters. To enforce strict matching, usefalseinstead. -
targetColumn– The name of the new column to be created.
Example
{
"RecipeAction": {
"Operation": "FIND",
"Parameters": {
"sourceColumn": "city",
"pattern": "[AEIOU]",
"position": "1",
"ignoreCase": "false",
"targetColumn": "begins_with_a_vowel"
}
}
}