akshaiya
New User
Joined: 17 Sep 2005 Posts: 49
|
|
|
|
I want to expand the message msg1,msg2 by matching it in the second file.
first file
Code: |
9----+----0----+----1----+----2----+----3----+-
fileA no date ind msg1 msg2
100054,000, ,20070503,N, ,BBBB , AAAA ,
100054,000 ,20071503,N, ,AAAA , CCCC ,
100054,000 ,20071503,N, ,BBBB ,AAAA ,
100054,000 ,20072503,Y, ,VVVV , ,
100054,000 ,20071503,Y, ,MMMM , ,
100054,000 ,20070503,N, ,QQQQ , , |
second file
Code: |
AAAA k1256 is missing
BBBB achieved ydt
CCCC result set to NO
DDDD cleanup reqd |
result :
Code: |
9----+----0----+----1----+----2----+----3----+-
fileA no date ind msg1
100054,000, ,20070503,N, ,achieved ydt
,k1256 is missing
100054,000 ,20071503,N, , k1256 is missing
, result set to NO
|
Totally msg codes are 5. msg1 to msg5. Some rows have only one msg1 . some may have all the five.
can anyone let me know how to handle this in icetool or some other utility
hope iam clear in my query.
thanks. |
|