String

The following functions allow you to search or modify string values in expression bindings.

📄️ concat

Concatenates all of the strings passed in as arguments together.

Returns the given string with special SQL characters escaped.

Returns the given string after being escaped to be valid for inclusion in XML.

Returns an integer value of the binary formatted string argument.

Returns an integer value of the hex formatted string argument.

Returns an integer value of the octal formatted string argument.

Searches for the first occurrence of the substring inside of string.

Searches for the last occurrence of the substring inside of string.

Returns count characters from the left side of string, where count and string are the arguments to the function.

Returns the length of the argument, which may be a string or a dataset.

Takes a string and returns a lower-case version of it.

Returns a string version of the number argument, formatted as specified by the pattern string.

Repeats the given string some number of times.

Finds all occurrences of a substring inside of a source string, and replaces them with the replacement string.

Returns count number of characters starting from the right side of string, where count and string are the arguments to the function.

Takes the starting string and splits it into substrings

Returns a formatted string using the specified format string and arguments.

Will return the portion of the string from the startIndex to the endIndex, or end of the string if endIndex is not specified

Returns a binary formatted string representing the unsigned integer argument.

Returns a hex formatted string representing the unsigned integer argument.

Returns an octal formatted string representing the unsigned integer argument.

Takes the argument string and trims of any leading and/or trailing whitespace

Takes a string and returns an upper-case version of it.