Text functions overview

Text functions manipulate or evaluate string data. You can use them to standardize string inputs, and build logical statements based on strings data.

Use double quotation marks, "...", to identify strings in a formula.

To include quotes in your string, use a backslash, \ , to indicate that the following quote is part of the string.

Concat
Combines strings by appending them
Contains
Determines if a string contains the specified substring(s); returns True or False
EndsWith
Determines if a string ends with the specified substring; returns True or False
Find
Returns the index where it first finds the specified substring within a string; returns 0 if not found
ILike
Returns True if the string matches the pattern; case-insensitive
Left
Returns the left portion of the string (the beginning), up to specified number of characters
Len
Returns the number of characters in a string, including spaces
Like
Returns True if the string value matches the pattern; case-sensitive
LPad
Sets the string to a desired length by adding or removing characters at the front; uses an optional fill character, or defaults to extra spaces
Lower
Converts a string to lower case
LTrim
Removes leading spaces from a string
MD5
Calculates the hash value of a string for the MD5 message-digest algorithm
Mid
Returns a substring from a string, defined by offset and length
Same as Substring
Proper
Converts text to proper case, capitalizing the first letter of each word
RegexpExtract
Returns the substring that matches a regular expression within a string
RegexpMatch
Returns TrueΒ if a string matches a regular expression
RegexpReplace

Returns a String for a pattern and replaces it with a specified String

Repeat
Returns the result of repeating the string a specified number of times
Replace
Replaces every instance of a specified string with a replacement string
Reverse
Reverses the order of characters in a string
Right
Returns the right portion of a string (the end), up to the specified number of characters
RPad
Sets the string to a desired length by adding or removing characters at the end; uses an optional fill character, or defaults to extra spaces
RTrim
Removes trailing spaces from the end of a string
SplitPart
Splits the string into multiple parts at the positions of each appearance of theΒ delimiter, and returns the nth part of the string at the specified position
StartsWith
Determines if a string starts with the specified substring;Β returns True or False
Substring
Returns a substring from a string, defined by offset and length
Same as Mid
Trim
Removes both leading and trailing spaces from a string
Upper
Converts a string to upper case (all capitals)