Filemaker Pro 8.5 Educational Maintenance T0 TJ087LL/A User Manual
Product codes
TJ087LL/A
178 FileMaker Functions Reference
Description
Returns a text result containing the numberOfWords from text, beginning at
startingWord.
startingWord.
Note
The ampersand (&) and hyphen (-) characters identify the beginning of a new word.
Examples
MiddleWords(“Plaid Canvas Suitcase”;2;2) returns
Canvas Suitcase
.
MiddleWords(Name;1;2) returns
Brigitte Erika
, when the Name field contains Brigitte
Erika Durand.
NumToJText
Format
NumToJText(number;separator;characterType)
Parameters
number - any numeric
separator - a number from 0 - 3 representing a separator
characterType - a number from 0 - 3 representing a type
characterType - a number from 0 - 3 representing a type
Data type returned
text
Description
Converts Roman numbers in number to Japanese text. If the value for separator and
characterType are blank or other than 0 to 3, then 0 is used.
Separator:
0 - no separator
1 - every 3 digits (thousands)
2 - ten thousands(
characterType are blank or other than 0 to 3, then 0 is used.
Separator:
0 - no separator
1 - every 3 digits (thousands)
2 - ten thousands(
) and millions(
) unit
3 - tens(
), hundreds(
), thousands(
), ten thousands(
) and millions(
) unit
Type:
0 - half width (Hankaku) number
1 - full width (Zenkaku) number
2 - Kanji character number
3 - Traditional-old-style Kanji character number
0 - half width (Hankaku) number
1 - full width (Zenkaku) number
2 - Kanji character number
3 - Traditional-old-style Kanji character number