Functions Reference

Text functions
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 quotes)
• expressions having a text result
Click a function name for details.
This function Returns
Exact, page 159 1 (True) for an exact match, or 0 (False) for a mismatch between two text strings
or container fields
.
Filter, page 159 Only the specified characters, in the order that they were originally entered in the
text.
FilterValues, page
160
Only the specified values, in the order that they were originally entered in the text.
GetAsCSS, page
161
The specified text, converted to the CSS (Cascading Style Sheets) format.
GetAsDate, page
162
Dates in the specified text as field type
date, for use in formulas involving dates or
date functions.
GetAsNumber, page
162
Numbers in the specified text as field type number, for use with formulas involving
numbers or numeric functions.
GetAsSVG, page
163
The specified text, converted to the SVG (Scalable Vector Graphics) format.
GetAsText, page
164
The specified number, date, time or timestamp as field type text, for use with
formulas involving text or text functions.
GetAsTime, page
164
Times or timestamps in the specified text as field type time, for use with formulas
involving the time or timestamp functions.
GetAsTimestamp,
page 165
The specified data as field type timestamp, for use with formulas involving
timestamps.
GetValue, page 165 A specific value from a list of values.
Hiragana, page 166 Hiragana converted from Katakana (hankaku and zenkaku).
KanaHankaku, page
166
Hankaku Katakana converted from Zenkaku Katakana.
KanaZenkaku, page
167
Zenkaku Katakana converted from Hankaku Katakana.
KanjiNumeral, page
167
Kanji numerals converted from Arabic numerals.