Filemaker Pro 8.5 Advanced Maintenance TG761Z/A Manuale Utente
Codici prodotto
TG761Z/A
Chapter 12
|
Text functions 187
Description
Returns text stripped of all leading and trailing spaces.
Tip
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.
spaces accidentally typed during data entry.
Examples
Trim(“ Tom ”) returns
Tom
.
Trim(Middle(“00230013 William 1234”;9;9)) returns
William
.
TrimAll
Format
TrimAll(text;trimSpaces;trimType)
Parameters
text - any
field
trimSpaces - 0 or False, 1 or True
trimType - 0 through 3 depending on the trim style that you wish to use
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
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 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.