Re: [Clip] Delete Dupe Line CSV
> On 8/30/2013 2:03 PM, Mike Breiding - Morgantown WV wrote:>Mike,
> > Greetings,
> > I have a CSV file with numerous duplicate lines.
> > Any clips out there to delete the duplicate lines?
> > Thanks, Mike
> Re: Deleting duplicate lines
> Fri Aug 30, 2013 5:01 pm (PDT) . Posted by:"hsavage" hrs62930
> I use CSVed now and then for CSV files. But, if you're correct and theCVed did the trick and pointed out some erroneous entries as well.
> referenced lines are identical, that means each 'record' or series of
> 'fields' is followed by a carriage return.
> If this is the case you can eliminate the dupes by loading into NTP and
> sorting. This, of course will sort all records in the database
> alphabetically, either ascending or descending. You make the call.
Reduced 4307 entries to 116.
Thanks to all who helped with this.
It saved me a lot of time and hair-pulling.