Functions Reference

Chapter 12
|
Text functions 161
Chapter 12
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 163 1 (True) for an exact match, or 0 (False) for a mismatch between two text strings
or container fields
.
Filter, page 164 Only the specified characters, in the order that they were originally entered in the
text.
FilterValues, page
164
Only the specified values, in the order that they were originally entered in the text.
GetAsCSS, page
165
The specified text, converted to the CSS (Cascading Style Sheets) format.
GetAsDate, page
166
Dates in the specified text as field type
date, for use in formulas involving dates or
date functions.
GetAsNumber, page
166
Numbers in the specified text as field type number, for use with formulas involving
numbers or numeric functions.
GetAsSVG, page
167
The specified text, converted to the SVG (Scalable Vector Graphics) format.
GetAsText, page
168
The specified number, date, time or timestamp as field type text, for use with
formulas involving text or text functions.
GetAsTime, page
168
Times or timestamps in the specified text as field type time, for use with formulas
involving the time or timestamp functions.
GetAsTimestamp,
page 169
The specified data as field type timestamp, for use with formulas involving
timestamps.
GetAsURLEncoded,
page 169
The specified text, converted with URL (Uniform Resource Locators) encoding.
GetValue, page 170 A specific value from a list of values.
Hiragana, page 171 Hiragana converted from Katakana (hankaku and zenkaku).
KanaHankaku, page
171
Hankaku Katakana converted from Zenkaku Katakana.
KanaZenkaku, page
172
Zenkaku Katakana converted from Hankaku Katakana.