Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
Chapter 12
|
Text functions 161
Chapter 12
Text functions
Text
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:
•
Text functions operate on these parameters:
•
fields of type text
•
(in quotes)
•
Click a function name for details.
This function
Returns
1
(True) for an exact match, or
0
(False) for a mismatch between two text strings
.
Only the specified characters, in the order that they were originally entered in the
text.
text.
Only the specified values, in the order that they were originally entered in the text.
The specified text, converted to the
format.
Dates in the specified text as
date, for use in
involving dates or
date functions.
Numbers in the specified text as field type number, for use with formulas involving
numbers or numeric functions.
numbers or numeric functions.
The specified text, converted to the SVG (Scalable Vector Graphics) format.
The specified number, date, time or timestamp as field type text, for use with
formulas involving text or text functions.
formulas involving text or text functions.
Times or timestamps in the specified text as field type time, for use with formulas
involving the time or timestamp functions.
involving the time or timestamp functions.
The specified data as field type timestamp, for use with formulas involving
timestamps.
timestamps.
The specified text, converted with URL (Uniform Resource Locators) encoding.
Hiragana converted from Katakana (hankaku and zenkaku).
Hankaku Katakana converted from Zenkaku Katakana.
Zenkaku Katakana converted from Hankaku Katakana.