Joined: 15 Dec 2005 Posts: 72 Location: RALEIGH NC, USA
Hello everyone,
This is my challenge, I have VARIABLE length input file and want to remove blanks, and squeeze data to left, change all *'s to zeroes, ignore some data and extract other data to finally create an output file in FIXED length.
How can all this be done in one DFSORT job ? or is iyt more that one.
would someone be able to provide solution ?
Input file looks like this
00375 1035 49ABCD
00378 *151 01ABCDE FGHIJKLM
35680 *880 99ZZZZZZ XXXX
OUTPUT TO LOOK LIKE THIS...
003751035ABCD
003780151ABCDE FGHIJKLM
356800880ZZZZZZ XXXX
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
If that's the way your data looks, then you don't need SQZ to do what you want to do. You say you have variable length input, but I suspect it's really FB with records having different numbers of blanks at the end rather than VB. At any rate, here's FB and VB versions of the job:
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Per your offline note, you really are trying to convert from VB to FB as you said originally but I misunderstood. Here's how to do that in one pass with DFSORT. I assume you're using TRAN=ALTSEQ because the * can be anywhere in the record, so I've factored that in.