There is an input file that is in CSV format.
Dedupe the file based on a specific column (the column will be specified by the user).
An example input file:
Acoustic Jungle,24611
Acoustic Mayhem (Big Band),HTE189
Acoustica,24613
Acquiesce,24614
Action Is,24615
Active Radio,HTE190
Acustyka,24616
Acústyka!,24617
Adam Carroll,HTE196
Adam Cartwright,25077
Adam Donmoyer,25422
Adam Franklin, HTE1553
Adam Holzman,25954
Adam Keith Garner,25702
Adam Stewart,27175
Adam Stokes,27181
Adam Stokes & the Green Muse,27181
Adam Turner,27388
Adamello,24618
Addictions,24622
Addictions,24622
The output file in this case would be:
Acoustic Jungle,24611
Acoustic Mayhem (Big Band),HTE189
Acoustica,24613
Acquiesce,24614
Action Is,24615
Active Radio,HTE190
Acustyka,24616
Acústyka!,24617
Adam Carroll,HTE196
Adam Cartwright,25077
Adam Donmoyer,25422
Adam Franklin, HTE1553
Adam Holzman,25954
Adam Keith Garner,25702
Adam Stewart,27175
Adam Stokes,27181
Adam Turner,27388
Adamello,24618
Addictions,24622
Wherever there is a duplicate, use the first line.
Hi sir I can implement a Windows application or a Perl script to do this. I can have this done for you in less than an hour. Please let me know if you need more info.
Regards, Bryan