String manipulations

Variables of data type Text, Alt Text and Text Indexed support additional arguments to perform simple manipulations on the text value of the variable. For Indexed variables, the manipulation is performed on each item in the list (that is, before the items are sequenced).

If multiple arguments are present, the manipulations are performed in the order as they are listed in the table (regardless of the order in which they occur in the variable).

Argument

Value

Result

Space

One of "trim", "norm"

trim = leading and trailing white space removed

norm = trimmed and consecutive white space compressed to a single space

Case

One of "upper", "lower", "first", "word"

The string converted to the specified case (first = first character is upper case, word = first character of every word is upper case)

After

Search string (non-empty)

The substring after (and not including) the last occurrence of the search string

Before

Search string (non-empty)

The substring before (and not including) the first occurrence of the search string

Segment

Start and end index (one-based) separated by a comma or a hyphen; if one of the indices is missing this indicates the start or end of the string

The substring between and including the characters indicated by the indices

Search

Regular expression (use anchors to match start or end of string)

The first substring that matches the regular expression

See also: