GermanNumText

This function is a German version of the NumText function. The NumText function provides written numeric equivalents, such as One Hundred Twenty for 120. The GermanNumText function serves the same purpose, but its output is in German.

Syntax

GermanNumText (Number, DollarWord, CentWord, Decimode)

Parameter

Description

Number

Enter a valid amount. The default is the current field value.

DollarWord

Enter the word you want to use instead of dollars. The default is:

"euro"

CentWord

Enter the word you want to use instead of cents. The default is:

"cents"

Decimode

Choose from these options:

1 - numeric decimal amount
2 - spell decimal amount
3 - suppress zero, numeric decimal amount
4 - suppress zero, spell decimal amount

The default is "1"

Please note the system returns only lowercase letters.

Example

Function

Result

Explanation

Return(GermanNumText ( ))

If you entered 2000000, the system would return:

zweimillion euro und 0 cents

The current field value is returned in a written form using euro and cents. The zero (0) is displayed in a numeric decimal amount format.

Return(GermanNumText (123.45,,,2 ))

einhundertdreiundzwanzig euro und vierzig fünf cents

The written equivalent for 123.45 is displayed using Decimode 2 with the decimal spelled out.

See also

© Copyright 2017, Oracle and/or its affiliates. All rights reserved. Legal Notices

Open table of contents