UNIX for Dummies Questions & Answers

HI All,

I have a to write a shell script where a file will have I,D,U opertaions for example

Code:

Cust|I|1234|1234|MO|sysdate
Cust|I|3245|3245|MD|sysdate
Cust|I|1111|1111|PO|sysdate
Cust|D|3245|3245|Md|sysdate
Cust|U|1111|1111|Po|sysdate

My requuirement is ,if any two same records with insert and update operations then update record shud be deleted.similarly if any two same records with insert and delete operations then both insert and delete records shud be deleted from teh actual file.

so the final shud be like

Code:

Cust|I|1234|1234|MO|sysdate 
Cust|I|1111|1111|PO|sysdate

Below three records shud go to reject file

Code:

Cust|D|3245|3245|Md|sysdate
Cust|U|1111|1111|Po|sysdate
Cust|I|3245|3245|MD|sysdate

The file will have few thousand records every day,any such shell script would be very helpful.

Thanks in advance

Hi guy,
May this a not very good method.

Code:

awk '$2=="I"{I[$3$4]=$0}$2=="U"&&!I[$3$4]{U[$3$4]=$0}$2=="D"{if(I[$3$4]){delete I[$3$4]}else{D[$3$4]=$0}}
END{{for(i in I){print I[i]}}{for(u in U){print U[u]}}{for(d in D){print D[d]}}}' FS='|' file

Thanku very much Lucas_0418,

Can u please explain how exactly this works

You should be asking what bit of awk you did not understand, or show what you did understand - and what you are missing here

HI

I do understand the script overall ,but how to redirect the deleting records into a file in thi script

---------- Post updated at 03:02 PM ---------- Previous update was at 02:53 PM ----------

Thanks for the script a lot ...only i thing i require additional to the script is ...to redirect the records (which doesn't satisfy the conditions ) to a .REJ file.

Thanks in advance.

Hi Guys ,

Any help on this ....i cant move the rejected records to another file..
Please help

Thanks