Remove duplicate

Shell Programming and Scripting
1

Hi all,
I have a text file fileA.txt
DXRV|02/28/2006 11:36:49.049|SAC||||CDxAcct=2420991350
DXRV|02/28/2006 11:37:06.404|SAC||||CDxAcct=6070970034
DXRV|02/28/2006 11:37:25.740|SAC||||CDxAcct=2420991350
DXRV|02/28/2006 11:38:32.633|SAC||||CDxAcct=6070970034
DXRV|02/28/2006 11:39:40.754|SAC||||CDxAcct=2420991350
ADMX|02/28/2006 12:39:40.754|SAC||||CDxAcct=2420999999
ADMX|02/28/2006 12:40:40.754|SAC||||CDxAcct=2420999999
ADMX|02/28/2006 12:44:40.754|SAC||||CDxAcct=2420999999

if the record have CDxAcct=
and same Name then remove the CDxAcct have duplicate, only keep the new one
Name,date,location,A,B,C,D,CDxAcct=XXXX|CDxAcct=YYYY ....

As result it should be
DXRV,02/28/2006 11:36:49.049,SAC,,,,CDxAcct=2420991350|CDxAcct=6070970034
ADMX,02/28/2006 12:39:40.754,SAC,,,,CDxAcct=2420999999

How do you do that ??

2

here's something to start with.

Use awk's associative arrays. Your array index is the LAST field of your input [e.g. 'CDxAcct=2420991350'].

3

I got it, my mistake that'why it did not work .
Thanks