Syntax: trimAll ( text; trimSpaces; trimType )
textAny text expression or text field.
trimSpaces0 (False), 1 (True).
TRimType0 through 3 depending on the trim style.
Data type returned: Text
Returns text with all leading and trailing spaces removed, and takes into account different Unicode representations of spaces.
Set trimSpaces to 1 if you want to include the removal of full-width spaces between non-Roman and Roman characters. Set trimSpaces to 0 if you do not.
Characters are considered Roman if their Unicode values are less than U+2F00. Characters with values values greater than or equal to U+2F00 are considered non-Roman.
Characters within the Roman range belong 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.
The trimType parameter controls how the function returns text in the following ways:
Removes spaces between non-Roman and Roman characters and always leaves one space between Roman words.
Always includes a half-width space between non-Roman and Roman characters and always leaves one space between Roman words.
Removes spaces between non-Roman characters (reducing multiple spaces between non-Roman and Roman words to 1 space) and leaves one space between Roman words.
Removes all spaces everywhere.
In all cases, spaces between non-Roman characters are removed.
Returns James Aloysius Kinsella when the value of Full_Name is "James Aloysius Kinsella". It is useful for stripping extra spaces out of lengthy text fields.
Returns when the value of is .
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information