Middle of String Transformation
The Middle of String transformation extracts a substring from the source column, transforms it, and copies the result to the destination column.
You specify the substring by providing a start position and a maximum number of characters to include. Consider the following:
- The first character in the string occupies position 1.
- If you specify no maximum number of characters, all characters that occupy positions greater than or equal to the start position are included in the substring.
- If the start position falls beyond the end of the string, an empty string results.
You can further process the resulting substring by using:
- Trimming options, which include deleting leading, trailing, or embedded white spaces.
White space consists of the following characters: tab, line feed, vertical tab, form feed, carriage return, and space (0x09 – 0x0D, 0x20), as well as their Unicode equivalents.
- Case options, which include converting the substring to either uppercase or lowercase characters.
If the final result is too large to fit in the destination column, it is truncated.
The Middle of String transformation fails if the source or destination columns are not of a string data type.
To perform a Middle of String transformation