Set String

Kalipso - Form - Expressions - Functions - Functions Descriptions - String Functions - Set String

This Function returns a string with Value replacing a Source String according to a Rank and a Separator.

Parameters

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

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

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

• Value <string> - String to use for insert or replace.

Examples

• Example 1

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

• Example 2

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

• Example 3

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

If the Rank is higher than the number of parts, the result will be the source string concatenated with the missing separators and the Value.

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