Text functions

This function	Does this
Char	Returns the characters for the Unicode code points in the number.
Code	Returns the Unicode code points for the characters in the text.
Exact	Returns 1 (true) if the contents of any two fields match; otherwise, returns 0 (false).
Filter	Returns from textToFilter only those characters specified in filterText, in the order they were originally entered in textToFilter.
FilterValues	Returns a text result containing only the values that were provided in filterValues, in the order they were originally entered in textToFilter.
Furigana	Converts Japanese text to Hiragana, Katakana, or Roman text.
GetAsCSS	Returns text converted to the CSS (Cascading Style Sheets) format.
GetAsDate	Returns dates in text as field type date.
GetAsNumber	Returns only the numbers in text, as field type number.
GetAsSVG	Returns text converted to the SVG (Scalable Vector Graphics) format.
GetAsText	Returns data as field type text.
GetAsTime	Returns times or timestamps in text as field type time.
GetAsTimestamp	Returns text as field type timestamp.
GetAsURLEncoded	Returns text as URL (Uniform Resource Locator) encoding, for use as a URL.
GetValue	Returns the requested value given by valueNumber from listOfValues.
Hiragana	Converts Katakana (Hankaku and Zenkaku) in text to Hiragana.
KanaHankaku	Converts Zenkaku Katakana to Hankaku Katakana.
KanaZenkaku	Converts Hankaku Katakana to Zenkaku Katakana.
KanjiNumeral	Converts Arabic numerals to Kanji numerals.
Katakana	Converts Hiragana to Zenkaku Katakana.
Left	Returns the specified numberOfCharacters in text, counting from the left.
LeftValues	Returns values contained in text, according to the specified numberOfValues, counting from the left.
LeftWords	Returns text containing the specified numberOfWords in text, counting from the left.
Length	Returns the number of characters in a field, including all spaces, numbers, and special characters.
Lower	Returns all letters in specified text as lowercase.
Middle	Extracts the specified numberOfCharacters from text, starting at the specified character position.
MiddleValues	Returns text containing the specified numberOfValues in text, starting at startingValue.
MiddleWords	Returns text containing the specified numberOfWords from specified text, starting at startingWord.
NumToJText	Converts Arabic numerals to Japanese text.
PatternCount	Returns the number of occurrences of searchString in text.
Position	Returns the starting position of the specified occurrence of searchString in text.
Proper	Returns the first letter of each word in text as uppercase and all other letters as lowercase.
Quote	Returns the text form of text enclosed in quotation marks.
Replace	Replaces a string of characters in specified text with replacementText.
Right	Returns the specified numberOfCharacters in text, counting from the right.
RightValues	Returns values contained in text, according to the specified numberOfValues, counting from the right.
RightWords	Returns text containing the specified numberOfWords in text, counting from the right.
RomanHankaku	Converts from Zenkaku alphanumeric and symbols to Hankaku alphanumeric and symbols.
RomanZenkaku	Converts from Hankaku alphanumeric and symbols to Zenkaku alphanumeric and symbols.
SerialIncrement	Returns specified text and numbers, with the numbers incremented by the specified amount.
Substitute	Returns a text string with every occurrence of searchString in specified text replaced by replaceString.
Trim	Returns text stripped of all leading and trailing spaces.
TrimAll	Returns a copy of text with specified spaces (such as spaces between text, or non-Roman spaces such as full- and half-width) removed or inserted.
Upper	Returns all letters in specified text as uppercase.
ValueCount	Returns a count of the total number of values in specified text.
WordCount	Returns a count of the total number of words in specified text.

This function

Does this

Char

Returns the characters for the Unicode code points in the number.

Code

Returns the Unicode code points for the characters in the text.

Exact

Returns 1 (true) if the contents of any two fields match; otherwise, returns 0 (false).

Filter

Returns from textToFilter only those characters specified in filterText, in the order they were originally entered in textToFilter.

FilterValues

Returns a text result containing only the values that were provided in filterValues, in the order they were originally entered in textToFilter.