The BFNUME process changes numbers from various European formats (for example, 1.000, 1.000,00, $1000 or 1.000CR) to standard mathematical format (1000.00 or –1000.00) for purposes of calculation and comparison.
Formats accepted by the BFNUME process are:
Leading dollar and cent signs (for example, $1.000).
Leading or trailing minus sign (for example, –1.000 or 1.000–).
Leading plus sign (for example, +1.000).
Numbers with embedded periods (for example, 1.000.000,00).
Trailing letters CR or DB (for example, 1.000CR or 1.000DB).
Leading asterisks (for example, *1.000), that are often found in the amount field on checks.
Note: In European format, the decimal separator is a comma and the thousands separator is a period. In non-European format, the usage of period and comma are reversed. To convert non-European format numbers, see BFNUM – Convert Formatted Numbers.
The BFNUME process is performed according to the following steps:
Blanks, periods, dollar signs, cent signs, and asterisks are removed from the extracted data.
Control-M/Analyzer determines if the number is negative or positive. A number is negative if:
A minus sign is before or after the number.
The letters CR are after the number.
The number is enclosed in parentheses.
A number is positive if:
No indication that the number is negative exists.
The number ends with the letters DB.
If the result is blank, Control-M/Analyzer assumes the number is zero.
If the number starts with a comma, Control-M/Analyzer inserts a zero before the comma (for example, ,75 is modified to 0,75).
Table 228 BFNUME – Convert European Style Numbers Example