Substring transformation
A transformation type Substring will transform data from the incoming file by selecting a subset of the string. The value for Start position is required and defines the start position of the string. The value for End Position is optional and defines the end position of the string. The value of the end position must be higher than the value of the start position. The start position is inclusive, so zero is the start position for the first character of a string. The end position is exclusive.
Example: If you have the string “Johnathan” and select 3 for Start position and 8 for End position, the transformed data will be “natha”. If only the start position is defined as 3 without an end position, the transformed data will be "nathan".
To configure a substring transformation:
- Locate the data model attribute you want transformed and click its Transform link. The Transform dialog is displayed, and it shows the source fields (source) and schema attributes (target).
- Use the Transformation type list to select Substring.
- In the Start position field, use the arrows to select a value. The first position is zero. Optionally, select an end position in the End position field. Values for the end position must be higher than values for the start position.
- Optionally, test the transformation by entering a value in the Sample input field. The transformed value will display in the Output field.
- Click Apply.