Extract String

Kalipso - Form - Expressions - Functions - Functions Descriptions - String Functions - Extract String

This Function returns a string, extracted from the specified Source string, according to a Rank and a Separator.

Parameters

• Source string <string> - String from where to extract the substring.

• Rank <numeric> - Order of the substring to extract.

• Separator <string> - String used as a separator in the Source string, to divide it.

Examples

• Example 1

ExtractString("001;Kalipso Studio;5000;Software", 2, ";") Result = Kalipso Studio

• Example 2

ExtractString("001;Kalipso Studio;5000;Software", 1, ":") Result = 001;Kalipso Studio;5000;Software

• Example 3

ExtractString("001;Kalipso Studio;5000;Software", 2, ":") Result =

If the Rank is higher than the number of parts, the result will be an empty string.

If the Separator doesn’t exist and the specified Rank is 1, the result will be the specified Source string.