Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual
Product codes
TJ083LL/A
188 FileMaker Functions Reference
Characters within the non-Roman range are those belonging to the CJK symbols/
punctuations area, Hiragana, Katakana, Bopomofo, Hangul compatibility Jamo, Kanbun,
CJK unified ideographs, and so on.
Spaces are removed or inserted depending on the value of trimType, as given in the
punctuations area, Hiragana, Katakana, Bopomofo, Hangul compatibility Jamo, Kanbun,
CJK unified ideographs, and so on.
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(
) returns
if the value of
field is
TrimAll(
) returns
Upper
Format
Upper(text)
Parameter
text - any
Data type returned
text
This trimType value
Does this
0
Removes all spaces between non-Roman and Roman characters (always leave
one space between Roman words).
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).
(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).
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