Re: import file some numbers in scientific notation

I don't have access to the creating of the original .xlsx or the conversion
to .csv (done by a bank) - but the .csv is what i have to import. This is
in a automated stream, so user downloads from bank, and run through
clp/rpgle process to update the Power i application.
this is value in csv 1.10001E+12
this is value if i open csv with Excel and format column 1100009250903 as a
number...

this rpgle does not work - eval @pnbr = %float(@p20) - it
returned 1100010000000

If this automated process becomes a series of steps in Excel to reformat
the csv before processing - well... it is what it is ....

(pardon me if Gmail's browser editor really messed up the copy/paste (must
be ai...)

Jim





On Mon, May 1, 2023 at 6:24 PM John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

On Mon, May 1, 2023 at 4:15 PM Jim Franz <franz9000@xxxxxxxxx> wrote:

I cannot control or alter the source of the import files.

Does this mean you do not have access to the CSV?

Is there a rpgle or db2 sql method to convert these back exactly to the
numbers they exported via .csv file?

If you do not have the CSV, then I'm not sure. There *might* not be
any reliable way to recover the original values exactly. It depends on
several different factors.

The more "upstream" you can get, the better.

John Y.
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.