Functions Reference

Text functions
F
ILEMAKER FUNCTIONS REFERENCE 331
TrimAll
Purpose
Returns a copy of text with specified spaces (such as spaces between text, or non-Roman spaces
such as full- and half-width) removed or inserted.
Format
TrimAll(text;trimSpaces;trimType)
Parameters
text - any text expression or text field
trimSpaces - 0 or False, 1 or True
trimType - 0 through 3 depending on the trim style that you wish to use
Data type returned
text
Originated in
FileMaker Pro 6.0 or earlier
Description
Use TrimAll to work with spaces between text or non-Roman spaces such as full- and half-width
spaces; otherwise, use the
Trim function.
Set trimSpaces to True (1) if you want to remove full-width spaces. Set trimSpaces to False (0)
if you want to keep full-width spaces.
Note Full-width spaces are only present in some non-Roman languages like Japanese. If you only
use Roman languages, set trimSpaces to False (0).
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, sub-scripts, 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.