SUBSTRING - Amazon Glue DataBrew
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

SUBSTRING

Returns in a new column some or all of the specified strings in the source column, based on the user-defined starting and ending index values.

Parameters

  • sourceColumn – The name of an existing column.

  • startPosition – The character position to begin with, from the left end of the string.

  • endPosition – The character position to end with, from the left end of the string.

  • targetColumn – The name of the new column to be created.

Note

You can specify either sourceColumn or value, but not both.

Example

{
    "RecipeAction": {
        "Operation": "SUBSTRING",
        "Parameters": {
            "sourceColumn": "last_name",
            "startPosition": "5",
            "endPosition": "8",
            "targetColumn": "chars_5_through_8"
        }
    }
}