Functions Reference

Table Of Contents
FILEMAKER FUNCTIONS REFERENCE 226
Data type returned
text
Originated in
FileMaker Pro 6.0 or earlier
Description
Set trimSpaces to True (1) if you want to include the removal of full-width spaces between non-
Roman and Roman characters. Set trimSpaces to False (0) if you do not.
A character is considered Roman if its Unicode value is less than U+2F00. Any character whose
Unicode value is greater than or equal to U+2F00 is considered non-Roman.
Characters within the Roman range are those belonging to the following character blocks: Latin,
Latin-1 Supplement, Latin Extended-A & B, IPA Extensions, Spacing Modifier Letters, Combining
Diacritical Marks, Greek, Cyrillic, Armenian, Hebrew, Arabic, Devanagari, Bengali, Gurmukhi,
Gujarati, Oriya, Tamil, Telugu, Kannada, Malayalam, Thai, Lao, Tibetan, Georgian, Hangul Jamo,
and additional Latin and Greek extended blocks.
Symbols within the Roman range include punctuation characters, superscripts, subscripts, currency
symbols, combining marks for symbols, letter-like symbols, number forms, arrows, math operators,
control pictures, geometric shapes, dingbats, and so on.
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 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.
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