EXTRACT_BETWEEN_POSITIONS - AWS Glue DataBrew

EXTRACT_BETWEEN_POSITIONS

Creates a new column, based on character positions, 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.

  • startPosition – The character position at which to perform the extract.

  • endPosition – The character position at which to end the extract.

Example

{ "RecipeAction": { "Operation": "EXTRACT_BETWEEN_POSITIONS", "Parameters": { "endPosition": "9", "sourceColumn": "last_name", "startPosition": "3", "targetColumn": "characters_3_to_9" } } }