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

EXTRACT_BETWEEN_DELIMITERS

Creates a new column, based on delimiters, from the values in an existing column.

Parameters

  • sourceColumn – The name of an existing column.

  • targetColumn – The name of the new column to be created.

  • startPattern – A regular expression, indicating the character or characters that begin the delimited values.

  • endPattern – A regular expression, indicating the delimiter character or characters that end the delimited values.

Example

{
    "RecipeAction": {
        "Operation": "EXTRACT_BETWEEN_DELIMITERS",
        "Parameters": {
            "endPattern": "\\/",
            "sourceColumn": "info_url",
            "startPattern": "\\/\\/",
            "targetColumn": "raw_url"
        }
    }
}