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 MD₅ 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 n^th 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)

Was this page helpful?

Yes No