SUBSTRING (function)

The SUBSTRING allows you to extract a specific portion of a text string (i.e. a sequence of characters). The first parameter, string, is the entire text from which you want to extract the substring. The starting position is given by start and the ending position is given by end. If you try to extract a substring that is longer than the original string, the original string is retrieved. Moreover, if the start position is after the ending position, an empty string will be returned.

There are many applications for SUBSTRING: you can extract keywords, titles, authors from documents, change the appearance of a text, for example by extracting only the initials of a name, check whether a string contains a specific substring, such as whether a zip code is formatted correctly and, finally, concatenate multiple substrings to create new strings.

EXAMPLE

 x = SUBSTRING( "TEST", 2, 3 )