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:
 •
 •
text constants (in quotation marks)
 •
expressions having a text result
Click a function name for details.
 
1 (True) for an exact match, or 0 (False) for a mismatch between two text strings or container fields.
Dates in the specified text as field type date, for use in formulas involving dates or date functions.
Topics in this section
Char
Code
Exact
Filter
FilterValues
GetAsCSS
GetAsDate
GetAsNumber
GetAsSVG
GetAsText
GetAsTime
GetAsTimestamp
GetAsURLEncoded
GetValue
Hiragana
KanaHankaku
KanaZenkaku
KanjiNumeral
Katakana
Left
LeftValues
LeftWords
Length
Lower
Middle
MiddleValues
MiddleWords
NumToJText
PatternCount
Position
Proper
Quote
Replace
Right
RightValues
RightWords
RomanHankaku
RomanZenkaku
SerialIncrement
Substitute
Trim
TrimAll
Upper
ValueCount
WordCount