Length

Number of characters in string

ToUpper

Convert to upper case

ToLower

Convert to lower case

Substring

Returns substring

Left

Returns left substring (beginning of string)

Right

Returns right substring (end of string)

Quote1

Returns input string in single quotes ('...')

Quote2

Returns input string in double quotes ("...")

ReplaceString

Replaces specific charaters in string

Replace

Parses string looking for occurences of {...}. When found, the contents within {...} is evaluated as a TOPICA Basic expression, and the resulting value (which should be of type string) is substituted in place of {...}.

Concat

Concatenates any number of string parameters. Any null values among the input parameters are ignored.

ConcatNull

Concatenates any number of string parameters . If one or more of the parameters are null, the result is null.

Pad_Left

Pads a string to the left in a field with specified width.

Pad_Right

Pads a string to the right in a field with specified width.