String Functions

📄️ Char (character)

Returns the character described by the ASCII code given as the scalar input.

📄️ CharIndex (character index)

Returns the index (position within the string, counting from the left) of the given character within the given string.

📄️ DelimitedText

Builds a delimiter-separated string.

📄️ Left

Returns the specified number of character or characters from the beginning of a specified text string, based on the number of characters specified in the…

📄️ Len (length)

Returns the number of characters in a specified text string.

📄️ Lower

Converts all uppercase letters in a text string to lowercase.

📄️ LTrim (left trim)

Removes all spaces from the beginning (left side) of the specified text.

📄️ Mid

Returns a specified number of characters from a specified text string, starting at a specified position.

📄️ Proper

This function converts the given string to proper case.

📄️ RegexFind

Returns the boolean value if the pattern is found in the input string.

📄️ RegexReplace

Replace the input string that matches the specified pattern with the replacement string.

📄️ Replace

Replace replaces part of the specified text string, based on the number of characters specified, with a different specified text string.

📄️ Rept (repeat)

Repeats the specified text a specified number of times.

📄️ String Functions

📄️ Reverse

Returns the reverse of the specified text string.

📄️ Right

Returns the specified number of character or characters at the end of a specified text string, based on the number of characters specified in the scalar input.