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: