Replaces a substring based on start and end positions.
Configuration Options
- Select Fields: Choose one or more fields to transform.
- Start Index: The first character to replace. Indexing starts at 1.
- End Index: The last character to replace.
- Replacement: The string that replaces the substring between the start and end positions.
Example
| Input Field (Code) | Start Index | End Index | Replacement | Output |
|---|---|---|---|---|
| 20015 2175 | 6 | 6 | - | 20015-2175 |
| XYZ0012345 | 4 | 8 | 00000 | XYZ000005 |