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 – If true, ignore differences of case (between uppercase and lowercase) among letters. To enforce strict matching, use false instead.

• 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"
        }
    }
}