Filemaker Pro 8.5 Educational Maintenance T0 TJ087LL/A User Manual

Chapter 12

  

|

  Text functions     187

Returns text stripped of all leading and trailing spaces. 

Use the Trim function to remove unneeded spaces when you convert files from other 

programs or systems that require a fixed number of characters per field, or to remove 
spaces accidentally typed during data entry.

Trim(“ Tom ”) returns 

.

Trim(Middle(“00230013 William 1234”;9;9)) returns 

.

TrimAll(text;trimSpaces;trimType)

text - any 

field

trimSpaces - 0 or False, 1 or True
trimType - 0 through 3 depending on the trim style that you wish to use

text

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.