Makes string uppercase.
Makes a string lowercase.
Returns the length of a string.
Joins together the text arguments into a single text value.
To concatenate static text, surround it with double quotation marks. To concatenate double quotation marks, you need to use a backslash (\) as an escape character.
Repeats string by the specified number of times.
Removes whitespace at the beginning and end of string.
Extract howMany characters from the end of the string.
Extract how many characters from the beginning of the string.
Extract a substring of count characters starting at whereToStart.
Finds an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition.(startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be 0.
Similar to SEARCH(), though SEARCH() returns empty rather than 0 if no occurrence of stringToFind is found.
Searches for an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition. (startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be empty.
Replaces occurrences of old_text with new_text.
You can optionally specify an index number (starting from 1) to replace just a specific occurrence of old_text. If no index number is specified, then all occurrences of old_text will be replaced.
Replaces the number of characters beginning with the start character with the replacement text.