forum.vdsworld.com

LiquidCode · Posted: Wed May 04, 2005 5:23 am Post subject: Remove Dups by column

I am pulling my hair out on this one.

I have 2 lists that have items that are tab seperated and I want to remove duplicates based on a column. So If i have items that are that have the same item in column 3 remove one of the items.

example:
This would be a list

1@tab()2@tab()3
2@tab()3@tab()2
3@tab()4@tab()3

look for any duplicate items based on column 3 and remove all but one.

then the list would be

1@tab()2@tab()3
2@tab()3@tab()2

thanks!

LiquidCode · Posted: Wed May 04, 2005 6:07 am Post subject:

I got it.. ! Smile

Thanks anyway.

Skit3000 · Posted: Wed May 04, 2005 7:59 am Post subject:

Chris, maybe you can post the routine you used, so others can learn from it? Smile

LiquidCode · Posted: Wed May 04, 2005 2:10 pm Post subject:

I might be able to do that. It is just Mac's remove Dups code and I just used my NTH.dsu (you can find it on VDSWorld) to get the column to compair. I'll try to post it tonight. Smile