RIGHT_FIND - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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