Text functions can be used to analyze, rearrange, extract, and build text strings. For example, you could use the MiddleWords function to extract specific words from supplied text.
Text functions operate on these parameters:
•fields of type text
•text constants (in quotation marks)
•expressions having a text result
Click a function name for details.
This function | Does this |
Returns the characters for the Unicode code points in the number. | |
Returns the Unicode code points for the characters in the text. | |
Returns 1 (true) if the contents of any two fields match; otherwise, returns 0 (false). | |
Returns from textToFilter only those characters specified in filterText, in the order they were originally entered in textToFilter. | |
Returns a text result containing only the values that were provided in filterValues, in the order they were originally entered in textToFilter. | |
Converts Japanese text to hiragana, katakana, or roman text. | |
Returns text converted to the CSS (Cascading Style Sheets) format. | |
Returns dates in text as field type date. | |
Returns only the numbers in text, as field type number. | |
Returns text converted to the SVG (Scalable Vector Graphics) format. | |
Returns data as field type text. | |
Returns times or timestamps in text as field type time. | |
Returns text as field type timestamp. | |
Returns text as URL (Uniform Resource Locator) encoding, for use as a URL. | |
Returns the requested value given by valueNumber from listOfValues. | |
Converts katakana (hankaku and zenkaku) in text to hiragana. | |
Deletes a JSON data element specified by an object name, an array index, or a path. | |
Formats elements in JSON data to make them easier to read. | |
Queries JSON data for an element specified by an object name, an array index, or a path. | |
Lists the object names (keys) or array indexes in JSON data for an element specified by an object name, an array index, or a path. | |
Lists the values in JSON data for an element specified by an object name, an array index, or a path. | |
Adds or modifies an element in JSON data specified by an object name, an array index, or a path. | |
Converts zenkaku katakana to hankaku katakana. | |
Converts hankaku katakana to zenkaku katakana. | |
Converts arabic numerals to kanji numerals. | |
Converts hiragana to zenkaku katakana. | |
Returns the specified numberOfCharacters in text, counting from the left. | |
Returns values contained in text, according to the specified numberOfValues, counting from the left. | |
Returns text containing the specified numberOfWords in text, counting from the left. | |
Returns the number of characters in a field, including all spaces, numbers, and special characters. | |
Returns all letters in specified text as lowercase. | |
Extracts the specified numberOfCharacters from text, starting at the specified character position. | |
Returns text containing the specified numberOfValues in text, starting at startingValue. | |
Returns text containing the specified numberOfWords from specified text, starting at startingWord. | |
Converts arabic numerals to Japanese text. | |
Returns the number of occurrences of searchString in text. | |
Returns the starting position of the specified occurrence of searchString in text. | |
Returns the first letter of each word in text as uppercase and all other letters as lowercase. | |
Returns the text form of text enclosed in quotation marks. | |
Replaces a string of characters in specified text with replacementText. | |
Returns the specified numberOfCharacters in text, counting from the right. | |
Returns values contained in text, according to the specified numberOfValues, counting from the right. | |
Returns text containing the specified numberOfWords in text, counting from the right. | |
Converts zenkaku alphanumeric and symbols to hankaku alphanumeric and symbols. | |
Converts hankaku alphanumeric and symbols to zenkaku alphanumeric and symbols. | |
Returns specified text and numbers, with the numbers incremented by the specified amount. | |
Sorts a list of values based on the specified data type and locale. | |
Returns a text string with every occurrence of searchString in specified text replaced by replaceString. | |
Returns text stripped of all leading and trailing spaces. | |
Returns a copy of text with specified spaces removed or inserted. | |
Returns unique values that are in a list based on the specified data type and locale. | |
Returns all letters in specified text as uppercase. | |
Returns a count of the total number of values in specified text. | |
Returns a count of the total number of words in specified text. |