Functions Reference

Text functions
F
ILEMAKER FUNCTIONS REFERENCE 286
Text functions
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
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.