Loading ...
Sorry, an error occurred while loading the content.

Re: [Clip] Delete Dupe Line CSV

Expand Messages
  • Mike Breiding - Morgantown WV
    ... Mike, ... CVed did the trick and pointed out some erroneous entries as well. Reduced 4307 entries to 116. Thanks to all who helped with this. It saved me a
    Message 1 of 1 , Aug 31 1:08 PM
    • 0 Attachment
      > On 8/30/2013 2:03 PM, Mike Breiding - Morgantown WV wrote:>
      > > 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
      Mike,
      > I use CSVed now and then for CSV files. But, if you're correct and the
      > 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.

      CVed did the trick and pointed out some erroneous entries as well.
      Reduced 4307 entries to 116.
      Thanks to all who helped with this.
      It saved me a lot of time and hair-pulling.
      -Mike
    Your message has been successfully submitted and would be delivered to recipients shortly.