Given a number, DIGITS converts it to a character string of the specified length. The format of the field that contains the number must be Integer.
Is the number to be converted, stored in a field with data type Integer.
Integer between 1 and 10
Is the length of the returned character string. If length is longer than the number of digits in the number being converted, the returned value is padded on the left with zeros. If length is shorter than the number of digits in the number being converted, the returned value is truncated on the left.
The following request against the WF_RETAIL_LITE data source converts -123.45 and ID_PRODUCT to character strings:
DEFINE FILE WF_RETAIL_LITE MEAS1/I8=-123.45; DIG1/A6=DIGITS(MEAS1,6) ; DIG2/A6=DIGITS(ID_PRODUCT,6) ; END TABLE FILE WF_RETAIL_LITE PRINT MEAS1 DIG1 ID_PRODUCT DIG2 BY PRODUCT_SUBCATEG WHERE PRODUCT_SUBCATEG EQ 'Flat Panel TV' ON TABLE SET PAGE NOPAGE END
The output is: