SPLIT_COLUMN_MULTIPLE_DELIMITER - AWS Glue DataBrew

SPLIT_COLUMN_MULTIPLE_DELIMITER

Splits a column according to multiple delimiters.

Parameters

  • sourceColumn – The name of an existing column.

  • patternOptions – A JSON-encoded string representing one or more patterns that determine the split criteria.

  • pattern – One or more characters to use as a separator, when splitting the data.

  • limit – How many splits to perform. The minimum is 1; the maximum is 20.

  • includeInSplit – If true, includes the pattern in the new column; otherwise, the pattern is discarded.

Example

{
    "RecipeAction": {
        "Operation": "SPLIT_COLUMN_MULTIPLE_DELIMITER",
        "Parameters": {
            "limit": "1",
            "patternOptions": "[{\"pattern\":\",\",\"includeInSplit\":true},{\"pattern\":\" \",\"includeInSplit\":true}]",
            "sourceColumn": "description"
        }
    }
}