String Functions

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.