Concatenate
This will return a concatenated value of entered arguments.
concatenate(“abc”,”def”,”ghi”) returns the string “abcdefghi”, Up to 8 arguments can be entered.
Substring
This will return subset of a string.
substr(“abcdef”,3,2) returns “cd” (The 2 characters starting with the 3rd character in the string)
After
This will return subset of a string.
after(“c”,”abcdef”) returns “def” the characters immediately following the first appearance of “c”.
Length
This will return number of characters in a string.
Ien(“abcdef”) returns the integer 6
Before
This will return subset of a string.
before(“d”,”abcdef”) returns “abc” the characters immediately preceding the first appearance of “d”.