Posted: Tue Feb 22, 2011 4:57 am Post subject: Convert PS to excel
Hi,
I have a file (LRECL=80, RECFM=FB) with few records and need to create excel document. I am using below sort job to add the X'05' after each field to achieve it but getting ZERO suppression on the numeric fields that have numbers starting with ZERO.
The position 35 in input file has numbers like this -
Joined: 20 Oct 2006 Posts: 1411 Topics: 26 Location: germany
Posted: Tue Feb 22, 2011 7:28 am Post subject:
you could create an import macro, which would set the attribute of all cells to text. _________________ Dick Brenholtz
American living in Varel, Germany
Joined: 26 Nov 2002 Posts: 12377 Topics: 75 Location: San Jose
Posted: Tue Feb 22, 2011 11:07 pm Post subject:
mf_user wrote:
Kolusu, thanks for the information.
Got this tip from somebody to keep X'7D' after the numeric field. It allowed the zeroes to be retained after excel conversion. Is this ok too?
Thanks.
Do you even know what the hex value of X'7D' mean? It is nothing but Single Quote ' and you will see the single quote in your Excel data. If that is ok with you, use it. _________________ Kolusu
www.linkedin.com/in/kolusu
Of course, not ok though _________________ MF
==
Any training that does not include the emotions, mind and body is incomplete; knowledge fades without feeling.
==
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
