Extracts a portion of a string from the specified start position for the specified length. Indexing starts at 1.
Configuration Options
- Select Fields: Choose one or more fields to transform. Column names correspond to those listed in the Dataset Inspection tab.
- Start index: The position of the first character in the substring. The first character in the string is position 1.
- Length: The number of characters to include in the substring.
Example
| Input Field (Code) | Start Index | Length | Output |
|---|---|---|---|
| ABCD1234 | 5 | 4 | 1234 |