Re: import file some numbers in scientific notation

[Peter Dow <petercdow@xxxxxxxxx>]

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