MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » February 2014

RE: CpytoIMPF to a CSV File



fixed

Audrey,

Be careful not to let MS Excel confuse the true format of the actual content because of its' rendering intelligence when viewing a csv file.
Excel can display large numbers using the abbreviated format you describe despite the content being a long number when viewed via Notepad.
We avoid this issue by ensuring MS Excel displays these columns as text before saving it from Excel and potentially altering the format in the physical stream file.

peter

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Audrey Guardino
Sent: Friday, 14 February 2014 7:00 a.m.
To: midrange-l@xxxxxxxxxxxx
Subject: Re: CpytoIMPF to a CSV File

On Thu, Feb 13, 2014 at 11:09 AM, Audrey Guardino <aguardino85@xxxxxxxxx>wrote:

Is there a way to run this command and keep the integrity of Char
fields that start with a 0?

Below is the command I am executing, when opening the CSV file the
data formats itself in a weird notation, and also removes the last
digit (happens to be a check digit in this case).

Thanks
Audrey

===> CPYTOIMPF FROMFILE(TESTFILE) TOSTMF('\path\test.csv')
MBROPT(*ADD)
STMFCCSID(*STDASCII) STMFAUT(*DFT) RCDDLM(*CRLF) STRDLM
(*NONE) NULLIND(*YES)

The field is a UCC id which is defined in the file as 20 Char and the
value of the field is
00007292380143329052

The csv file presents it as 7.29e+15 with a value of 7292380143329050
essentially cutting off the leading zeros (which I can deal with) and
changing the last digit (which is my check digit that I need).

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.

#####################################################################################

This correspondence is for the named person's use only. It may contain confidential
or legally privileged information, or both. No confidentiality or privilege is waived
or lost by any mistransmission. If you receive this correspondence in error, please
immediately delete it from your system and notify the sender. You must not disclose,
copy or rely on any part of this correspondence if you are not the intended recipient.
Any views expressed in this message are those of the individual sender, except where
the sender expressly, and with authority, states them to be the views of Veda.
If you need assistance, please contact Veda on either :-
Australia 1300-762-207 or New Zealand +64 9 367 6200





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact