Re: import file some numbers in scientific notation

Hi Jim,

%float might be able to do it:

https://www.ibm.com/docs/en/i/7.3?topic=operations-rules-converting-character-values-numeric-values-using-built-in-functions

* Floating point data, for example '1.2E6', is only allowed for %FLOAT.
* For %FLOAT, the exponent is optional. It can be either 'E' or 'e'.
The sign for the exponent is optional. It must precede the numeric
part of the exponent.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx
pdow@xxxxxxxxxxxxxx /

On 5/1/2023 1:14 PM, Jim Franz wrote:

I cannot control or alter the source of the import files.
two columns have long strings of digits, account numbers, most are
readable, but some like
1.10001E+12 (scientific notation).
Is there a rpgle or db2 sql method to convert these back exactly to the
numbers they exported via .csv file?
User intervention, at this time, is not an option.
I read thru the thread history, in fact i had one a number of years ago,
but in that instance i controlled the source of the data.
Thank you,
Jim Franz