Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

SPLIT_COLUMN_BETWEEN_DELIMITER - AWS Glue DataBrew

SPLIT_COLUMN_BETWEEN_DELIMITER

Splits a column into three new columns, according to a beginning and ending delimiter.

Parameters
  • sourceColumn – The name of an existing column.

  • patternOption1 – A JSON-encoded string representing one or more characters that indicate the first delimiter.

  • patternOption2 – A JSON-encoded string representing one or more characters that indicate the second delimiter.

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

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

Example

{ "RecipeAction": { "Operation": "SPLIT_COLUMN_BETWEEN_DELIMITER", "Parameters": { "patternOption1": "{\"pattern\":\"H\",\"includeInSplit\":true}", "patternOption2": "{\"pattern\":\"M\",\"includeInSplit\":true}", "sourceColumn": "last_name" } } }
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.