Functions Reference

FILEMAKER FUNCTIONS REFERENCE 243
In all cases, spaces between non-Roman characters are removed.
* = insert space between non-Roman and Roman text if there isn’t one.
Examples
TrimAll(" Julian Scott Dunn ";0;0) returns Julian Scott Dunn.
TrimAll( ) returns if the value of field is
TrimAll( ) returns
Related topics
Contents
Functions reference (alphabetical list)
Upper
Purpose
Returns all letters in text as uppercase.
Format
Upper(text)
Parameters
text - any text expression or text field
Data type returned
text
1 Always includes a half-width space between non-Roman and Roman characters
(always leave one space between Roman words).
2 Removes spaces between non-Roman characters (reduce multiple space
between non-Roman and Roman words to 1 space; do not add spaces if there
are none; always leave one space between Roman words).
3 Removes all spaces everywhere.
This trimType value Does this
Type Non-Roman - Non-Roman Non-Roman - Roman Roman - Roman
0 Remove Remove 1 space
1 Remove 1 space* 1 space
2 Remove 1 space 1 space
3 Remove Remove Remove