String functions

Applies a different codepage to the field or text stated in the expression. The codepage must be in number format.

ApplyCodepage(text, codepage)

Capitalize() returns the string with all words in initial uppercase letters.

Capitalize(text)

Chr() returns the Unicode character corresponding to the input integer.

Chr(int )

Evaluate() finds if the input text string can be evaluated as a valid Qlik Sense expression, and if so, returns the value of the expression as a string. If the input string is not a valid expression, NULL is returned.

Evaluate(expression_text)

FindOneOf() searches a string to find the position of the occurrence of any character from a set of provided characters. The position of the first occurrence of any character from the search set is returned unless a third argument (with a value greater than 1) is supplied. If no match is found, 0 is returned.

FindOneOf(text, char_set[, count])

Hash128() returns a 128-bit hash of the combined input expression values. The result is a 22-character string.

Hash128(expr{, expression})

Hash160() returns a 160-bit hash of the combined input expression values. The result is a 27-character string.

Hash160(expr{, expression})

Hash256() returns a 256-bit hash of the combined input expression values. The result is a 43-character string.

Hash256(expr{, expression})

Index() searches a string to find the starting position of the nth occurrence of a provided substring. An optional third argument provides the value of n, which is 1 if omitted. A negative value searches from the end of the string. The positions in the string are numbered from 1 and up.

Index (text, substring[, count])

KeepChar() returns a string consisting of the first string less any of the characters contained in the second string.

KeepChar(text, keep_chars)

Left() returns a string consisting of the first n characters of the input string, where the number of characters is determined by the second argument.

Left(text, count )

Len() returns the length of the input string.

Len(text )

Lower() converts all the characters in the input string to lower case.

Lower(text)

LTrim() returns the input string trimmed of any leading spaces.

LTrim(text)

Mid() returns the part of the string starting at the position of the character defined by the second argument, with the string length defined by the third argument, or including the rest of the string if the third argument is omitted. The first position in the string is numbered 1.

Mid(text, start[, count])

Ord() returns the Unicode code point number of the first character of the input string.

Ord(char )

PurgeChar() returns a string containing all the characters in the input string except for any characters in the second argument string.

PurgeChar(text, remove_chars)

Repeat() forms a string consisting of the input string repeated the number of times defined by the second argument.

Repeat(text[, repeat_count])

Replace() returns a string after replacing all occurrences of a given substring within the input string with another substring. The function is non-recursive and works from left to right.

Replace(text, from_str, to_str)

Right() returns a string consisting of the of the last (right-most) characters of the input string, where the number of characters is determined by the second argument.

Right(text, count )

RTrim() returns the input string trimmed of any trailing spaces.

RTrim(text)

Subfield() is used to extract substring components from a parent string field, where the original record fields consist of two or more parts separated by a delimiter.

SubField(text, delimiter[, field_no ])

SubstringCount() returns the number of occurrences of the specified substring in the input string text. If there is no match, 0 is returned.

SubStringCount( text , substring)

TextBetween() returns the text in the parent string that occurs between the characters specified as delimiters. The text string between the first occurrence of the delimiters is returned unless an optional third argument (with a value greater than 1) is supplied.

TextBetween(text, sub_string)

Trim() returns the input string trimmed of any leading and trailing spaces.

Trim(text)

Upper() converts all the characters in the input string to upper case for all data in the expression.

Upper(text)