ADELIA |
VADELIA |
SADELIA |
WADELIA |
EADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(B) |
Warning: In the case of ADELIA programs, this function is not compatible with C generator.
Description
This predefined function is used to convert a numeric variable to an alphanumeric variable.
Syntax
Result = &NUM_TO_ALPHA(Numeric;Format)
Parameters
|
Description |
Contents |
Controls |
Result |
Destination alphanumeric variable. |
The alphanumeric variable is filled from left to right. |
|
Alphanumeric |
Numeric variable or constant to be converted to an alphanumeric type. |
Only NUM_E, NUM_P, NUM_BIN_2, NUM_BIN_4 and NUM_BIN_8 variables are permitted. The integer part of the value must lie in the range (+2 31 -1 , -(2 31 -1)). The value must not exceed 15 digits in length. |
Mandatory parameter. |
Format |
Alphanumeric variable or constant. |
Describes the format of the alphanumeric result variable. Refer to the table below for details of the possible formats. |
Optional parameter. |
Possible alphanumeric variable formats:
The alphanumeric variable's format is a combination of the following three types of format:
Decimal separators |
|
. |
A dot is used as the decimal separator. |
, |
A comma is used as the decimal separator. |
None |
The decimal separator will be the one defined: in the client workstation's system parameters for Visual Adelia applications, in the locale linked to the browser language for Adelia Web et Adelia Cloud applications, and in the job's DECFMT parameter for AS/400 5250 applications. |
Supplementary characters used with the integer part The integer part is expanded (packed) to match the numeric variable's definition as specified by the characters described below. |
|
0 |
The integer part is packed with zeros. |
# |
The integer part is packed with hashes (#). |
* |
The integer part is packed with asterisks (*). |
None |
The integer part is not packed. |
Formatting of positive and negative numbers |
|
"-" in final position |
A minus sign (-) is placed to the right of the alphanumeric variable if the number is negative. |
"-" in first position |
A minus sign (-) is placed to the left of the alphanumeric variable if the number is negative. |
"+" in final position |
A minus sign (-) is placed to the right of the alphanumeric variable if the number is negative. A plus sign (+) is placed to the right of the alphanumeric variable if the number is positive. |
"+" in first position |
A minus sign (-) is placed to the left of the alphanumeric variable if the number is negative. A plus sign (+) is placed to the left of the alphanumeric variable if the number is positive. |
None
|
With negative numbers, the minus sign (-) is placed as dictated by the client workstation's system parameters, in the case of Visual Adelia applications, and to the left of the number with AS/400 5250 applications. |
Example
ALPHA(15) RESULT
NUM_E(9,5) NUMERIC
NUMERIC=-12,45
RESULT=&NUM_TO_ALPHA(NUMERIC;'+0.')
*RESULT gives '-0012.45000'
RESULT=&NUM_TO_ALPHA(NUMERIC;'+*.')
*RESULT gives '-**12.45000'
NUMERIC=12,45
RESULT=&NUM_TO_ALPHA(NUMERIC;'+0.')
*RESULT gives '+0012.45000'
RESULT=&NUM_TO_ALPHA(NUMERIC)
*RESULT gives '12,45000'
RESULT=&NUM_TO_ALPHA(NUMERIC;'-')
*RESULT gives '12,45000'
NUMERIC=-12,45
RESULT=&NUM_TO_ALPHA(NUMERIC;'0.-')
*RESULT gives '0012.45000-'
ALPHA(4) RESULT
NUMERIC=12,45
RESULT=&NUM_TO_ALPHA(NUMERIC)
*RESULT gives '12,4'
RESULT=&NUM_TO_ALPHA(NUMERIC;'+')
*RESULT gives '+12,'
List of predefined functions by topic