Latest News

the latest news from our team

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.

Substring1

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.

Substring2

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.

Leave a Reply

Your email address will not be published. Required fields are marked *