REPLACE_TEXT - 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).

REPLACE_TEXT

Replaces a specified sequence of characters with another.

Parameters

  • sourceColumn – The name of an existing column.

  • pattern – Character or characters or a regular expression, indicating which characters should be replaced in the source column.

  • value – The replacement character or characters to be substituted.

Examples

{
    "RecipeAction": {
        "Operation": "REPLACE_TEXT",
        "Parameters": {
            "pattern": "x",
            "sourceColumn": "first_name",
            "value": "a"
        }
    }
}
{
    "RecipeAction": {
        "Operation": "REPLACE_TEXT",
        "Parameters": {
            "pattern": "[0-9]",
            "sourceColumn": "nationality",
            "value": "!"
        }
    }
}