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