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
orFalse
- EndsWith
- Determines if a string ends with the specified substring; returns
True
orFalse
- 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
orFalse
- 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)