RIGHT_FIND

Searching right to left, 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 right 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": "RIGHT_FIND",
        "Parameters": {
            "sourceColumn": "nationality",
            "pattern": "s",
            "position": "1",
            "ignoreCase": "true",
            "targetColumn": "ends_with_an_s"
        }
    }
}