MVSFORUMS.com

[spalanis]

Hi all,

I am trying to accomplish the following in one signle step using ICETOOL utility. Could anyone please suggest how I should go about it?.

I have an input file which looks like :
A 014 C
A 015 I
B 052 C
B 088 C
B 005 I

I need to have the output file which should have only rows having "C". But the challenge here is, the numeric field in "I" rows in "A" and "B" should be added as a new column in "A" and "B" record. For Example, my output should look like below

A 014 C 015
B 052 C 005
B 088 C 005


Please suggest how to do it.

Thanks,
Srini