Substring
The Substring Function extracts a string of characters from an incoming data file or a custom-built Variable:
1. To insert a substring, right-click the Variable and select Add Function > Substring.
2. From the Substring dialog box enter the starting position of the string you would like to extract and set the number of character to be extracted. Specifying a negative value (-1) in the Starting Character Position field indicates to start from the end of the string. ‘0’ is the starting position of the string.
TIP: Specifying a negative value (-1) in the Starting Character Position field indicates to start from the end of the string. ‘0’ is the starting position of the string.