Joined: 15 Dec 2005 Posts: 72 Location: RALEIGH NC, USA
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...
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:
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.