Functions Reference

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