Results 1 to 5 of 5

Thread: How can you remove duplicates in a textfile that is 200mb big?

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Jul 2003
    Posts
    1,269

    How can you remove duplicates in a textfile that is 200mb big?

    Anyone know how I can do this in VB? Is it possible?

  2. #2
    Frenzied Member I_Love_My_Vans's Avatar
    Join Date
    Jan 2005
    Location
    In the PHP compiler
    Posts
    1,275

    Re: How can you remove duplicates in a textfile that is 200mb big?

    Thats a massive text file, just my two cents but to remove duplicates would be a RAM hog.

  3. #3
    Cumbrian Milk's Avatar
    Join Date
    Jan 2007
    Location
    0xDEADBEEF
    Posts
    2,448

    Re: How can you remove duplicates in a textfile that is 200mb big?

    I would like to think it is possible and I think :/ it could be done without using too much ram, it just might not be that quick.
    If the general theory to remove duplicates involves comparing all the items with each other this version would involve comparing a chunk of items with all the others a chunk at a time.
    Can you show us a small sample of your big text file and confirm what you mean by duplicates.

  4. #4
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: How can you remove duplicates in a textfile that is 200mb big?

    Duplicate whats? Lines??? How big is each item etc...

  5. #5
    coder. Lord Orwell's Avatar
    Join Date
    Feb 2001
    Location
    Elberfeld, IN
    Posts
    7,628

    Re: How can you remove duplicates in a textfile that is 200mb big?

    it's possible but it's probably a better use of resources to break down the file into chunks of say 25mb, delete the dupes from those, then recombine to a new file and check that for duplicates again. As long as there are a lot of duplicates in the smaller files, you will have a much smaller final file to work on.
    My light show youtube page (it's made the news) www.youtube.com/@lightsofelberfeld
    Contact me on the socials www.facebook.com/lordorwell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width