Go to Contents
Previous
Page
 Next
Page
Contents > Functions reference (alphabetical list) > Text functions > TrimAll function
TrimAll function
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
Description
Returns a copy of text with all leading and trailing spaces removed.
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:
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.
In all cases, spaces between non-Roman characters are removed.
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
* = insert space between non-Roman and Roman text if there isn't one.
Examples
TrimAll(Japanese text string field name, trimSpace parameter set to 1 (True), and trimType parameter set to 0 ) returns Japanese text string if the value of Japanese text string field name field is Japanese text string with a space in the middle
TrimAll(Japanese text string containing some Roman characters, trimSpace parameter set to 1 (True), and trimType parameter set to 0 ) returns Japanese text string containing some Roman characters, with all spaces between non-Roman and Roman characters removed
Related topics
Functions reference (category list)
Functions reference (alphabetical list)
About formulas
About functions
Defining calculation fields
Using operators in formulas
Contents > Functions reference (alphabetical list) > Text functions > TrimAll function
Previous
Page
 Next
Page