Text Functions

Function Description
All Returns true if all the values specified in its list argument exist in the values argument.
Any Returns true if at least one value from the list exists in the values.
Begins Returns true if the text u begins with the text v; otherwise, returns false.
Concat This function returns a string that results from the concatenation, or joining, of two or more string values in an end-to-end manner.
Contains Returns true if text u contains text v; otherwise, returns false.
Ends Returns true if the text u ends with the text v, otherwise returns false.
Guid Returns a unique string in the XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX format, where each X represents a character from the 0123456789ABCDEF character set.
Left Returns the left part of a text value.
Len Returns the number of characters in a text.
List Concatenates all value arguments starting with the second argument, using the first argument as a delimiter between them.
Lower Returns text converted to lowercase.
Mid Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
NotLeft Returns what remains after excluding the left part of a text value.
NotRight Returns what remains after excluding the right part of a text value.
PadLeft Right-aligns the characters in the string by padding them on the left to achieve a specified total length.
PadRight Left-aligns the characters in the string by padding them on the right to achieve a specified total length.
Part Returns the specified part of a text value. The parts are separated by the occurrence of any delimiter character.
Proper Capitalizes the first letter in the text and any other letters in the text that follow any character other than a letter. Converts all other letters to lowercase letters, except for words that are entirely in uppercase, which are considered to be acronyms.
Replace Replaces substrings containing the old text with the new text in the given text.
Right Returns the right part of a text value.
Trim Returns text with leading and trailing white space characters removed.
Upper Returns text converted to uppercase.
URLEncode Encodes a URL string.
URLDecode Converts a URL-encoded string into a decoded string.
URLParam Extracts and decodes the value of a parameter from a URL’s query string.