EXTRACT_BETWEEN_DELIMITERS - AWS Glue DataBrew

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