The BFNUM process changes numbers from various non-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 BFNUM 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 commas (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 non-European format, the decimal separator is a period and the thousands separator is a comma. In European format, the usage of period and comma are reversed. To convert European format numbers, see BFNUME – Convert European Style Numbers.
The BFNUM process is performed according to the following steps:
Blanks, commas, 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 decimal point, Control-M/Analyzer inserts a zero before the decimal point (for example, .75 is modified to 0.75).
Table 227 BFNUM – Convert Formatted Numbers Example