Hi,
I have a input file which has three fields which should be numeric. so if the file has spaces in these fields i need to replace them with zeroes.
the following sort steps works fine for me.
but i have to use FINDREP seperately for each column. Is it possible to use one control card to FINDREP all the three fields?
Hi Anu,
I think you are going way complicated..
Please show us some sample input file records to get better solution.
(Use code Tag while posting sample records)
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Anu,
Your FINDREP statements don't make sense. I suspect you're just trying to replace a field that has a blank in 27, 47 or 67 with C'000000000000000.00' starting in that position, but FINDREP is NOT the right way to do that.
If that is what you're trying to do, then you can use a DFSORT job like the following:
If that's not what you're trying to do, then you need to explain what you are trying to do. Show an example of the records in each input file and what you expect for output. Explain the "rules" for getting fron input to output. Give the RECFM and LRECL of the input file.