Filemaker TH325Z/A Arkusz Danych Pobierz pdf (Strona 178)

178 FileMaker Functions Reference

Description

Returns a text result containing the numberOfWords from text, beginning at

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 expression or field containing a number

separator - a number from 0 - 3 representing a separator

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( ) 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

1 2 ... 173 174 175 176 177 178 179 180 181 182 183 ... 237 238

Brak uwag

Filemaker TH325Z/A Arkusz Danych Strona 178