Functions Reference

Text functions
F
ILEMAKER FUNCTIONS REFERENCE 332
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
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