Help

FILEMAKER PRO HELP 924
Spaces are removed or inserted depending on the value of trimType, as given in the following
tables:
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
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Upper
Purpose
Returns all letters in text as uppercase.
This trimType value Does this
0 Removes all spaces between non-Roman and Roman characters (always leave
one space between Roman words).
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.
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