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