Re: import file some numbers in scientific notation

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

Are you opening your file with notepad?

When we generate CSV's we put the numbers in there correctly, but when
users open the source file in excel (and possibly save it) the CSV file is
corrupted.


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.
> 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
> --
> 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.