String Functions

Perform string manipulation and formatting.

String Function	Description
Chr	Returns the character associated with the specified character code.
Concat	Generates a string concatenation of two or more expressions.
Concat	Generates a string concatenation of two or more expressions.
Contains	Determines if a text string or expression contains another text string or expression.
EndsWith	Determines if a text string or expression ends with another text string or expression.
EscapeJson	The EscapeJson function replaces invalid JSON characters (backspace, form feed, newline, carriage return, tab, double quote, and backslash) in a string with their valid equivalent.
EscapeXml	The EscapeXml function replaces invalid XML characters (ampersand, less than, greater than, quote, and apostrophe) in a string with their valid XML equivalent.
Format	The Format function formats a numeric or date expression.
Instr	The Instr function returns the position of the first occurrence of one string within another string.
IsRegexMatch	Determines if an expression matches a Regular Expression pattern.
IsWildcardMatch	Determines if an expression matches an DOS-style wildcard expression.
Left	The Left function returns a string containing a specified number of characters from the left side of a string.
Len	Returns the length of a string.
Length	Returns the length of a string.
Mid	The Mid function returns a substring of a string.
ProperCase	The ProperCase function returns a copy of a string with the first letter of every word capitalized and the rest of the letters in lower case.
RegexReplace	Replaces all occurrences of a Regular Expression pattern with a string.
RegexSelect	Returns first match of regular expression pattern going left to right.
Replace	The Replace function replaces all occurrences of a substring with another string.
Right	The Right function returns a string containing a specified number of characters from the right side of a string.
StartsWith	Determines if a text string or expression starts with another text string or expression.
ToInnerXml	Returns the inner xml (does not include the outer element) for an Entity or Entity Field.
ToJson	Returns the JSON for an Entity or Entity Field.
ToLower	The ToLower function returns a copy of a string, converted to all lower case.
ToUpper	The ToUpper function returns a copy of a string, converted to all upper case.
ToXml	Returns the xml for an Entity or Entity Field.
Trim	The Trim function returns a copy of a string with all leading and trailing spaces removed.
TrimWhitespace	The TrimWhitespace function removes leading, trailing, and duplicate whitespace from a string.