Use Google to find help fast. For example, search on "xpressdox choosefromlist".

The NumberPhrase Function

The NumberPhrase Function

This function converts a number to words, in a number of languages.

Suppose a data element with name ‘area’ has a value 1234:

<<NumberPhrase(area,"af","ToUpper")>>

yields “EEN DUISEND TWEE HONDERD VIER EN DERTIG”

<<NumberPhrase(area,"en","ToUpper")>>

yields “ONE THOUSAND TWO HUNDRED THIRTY-FOUR”

Notes:
i) The language code ‘af’ is the ISO639-2 code for Afrikaans (see ISO639-2 standards).
ii) Other languages supported are ‘en’ (US English, the default), ‘fr’ (French), ‘de’ (German), ‘en-uk’ , ‘en-za’ (which renders 1.10 as ‘One Comma One Zero’).
iii) The ‘ToUpper’ parameter is obvious, and could also be ‘ToLower’, or ‘Leave’ (which is the default).

The function NumberToWords is equivalent to NumberPhrase in all respects.

Leave a Reply