1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to Extract the Difference Between 2 .CSV Files

Discussion in 'Black Hat SEO' started by CoyoteAssassin, Dec 3, 2010.

  1. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    Ok, so I have created a contact group and uploaded my contacts, sent an email, and set bounces to inactive. The website where I get my leads from is updated often (making for a very large list).

    Currently, there are 65k contacts listed and each week they add an additional 10k. There are no filed parameters that allow me to sort out the new contacts from the old. My thought was to download the contacts and upload to Interspire (with the option to update the record). If abc@def.ghi is a bounce from the first import and I download it again the second time, though the email is inactive, will importing it again set the email to active?

    Basically, I need something that will allow me to extract the differences between the two .csv files as those will be the new records.

    I look forward to your input and it is good to be back.

    PS - This question was originally posted in a section that offered no assistance.
     
  2. xhpdx

    xhpdx Regular Member

    Joined:
    Sep 21, 2008
    Messages:
    331
    Likes Received:
    2,160
    Occupation:
    Coder
    Location:
    EU
    • Thanks Thanks x 1
  3. blackhatdavid

    blackhatdavid Regular Member

    Joined:
    Nov 5, 2009
    Messages:
    296
    Likes Received:
    106
    I would be interested in the same type of tool, but for a different purpose...I need to compare two lists of scraped URLs to tell me where the differences (additions) are.
     
  4. walker

    walker Junior Member

    Joined:
    Feb 19, 2009
    Messages:
    146
    Likes Received:
    49
    winmerge is cool, I always use it. it can tell the difference. it has a report feature for "extract" if that's what you mean.
     
    • Thanks Thanks x 1
  5. MaDeuce

    MaDeuce Newbie

    Joined:
    Oct 24, 2008
    Messages:
    45
    Likes Received:
    16
    Location:
    Austin, TX
    If you are on a unix/linux/os-x box, it is a one-liner using and 'sort' and 'diff'.
     
    • Thanks Thanks x 1
  6. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    Sweet. The suggestions are rolling in. No linux box here... it scares me. JK

    I'll give the suggested options a try.

    Thank you much. I hope this helps others.
     
  7. blackhatdavid

    blackhatdavid Regular Member

    Joined:
    Nov 5, 2009
    Messages:
    296
    Likes Received:
    106
    Assassin - Don't mean to jump in on your thread, but...

    I can't get WinDiff to work. I mean it will run. I got it to show differences similar to how WinMerge does one time. But from then on, after I select my two files, it just shows a blank pane. I can't get it to show any of either one of the files. It doesn't matter what options I select or change.

    WinMerge seems like the more "professional" of the two programs. I played with it and I think I understand what it is doing (for the most part). But I can't figure out how to get the results I need with a program of this type. I suspect Assassin is needing the same type of thing I am.

    Ideally, for my needs, I want the output to be a third list that contains ONLY the items that are in list2 that are NOT already in list1.

    If someone here is an expert in WinMerge and can tell me how to do that it would be great. I don't see it (without a lot of manual copy and pasting).

    Or if anyone knows of a way to compare two lists and give a resulting list that ONLY contains items that are UNIQUE to list #2, please let me know.
     
  8. walker

    walker Junior Member

    Joined:
    Feb 19, 2009
    Messages:
    146
    Likes Received:
    49
    I believe it has a report feature, you can sort the compare result first, then export report. I did this before, but do not have winmerge at hand now. but, pretty sure it can do this.
     
  9. blackhatdavid

    blackhatdavid Regular Member

    Joined:
    Nov 5, 2009
    Messages:
    296
    Likes Received:
    106

    I don't see how to do it in WinMerge, and like I said, I can't get WinDiff to work.
     
  10. blackhatdavid

    blackhatdavid Regular Member

    Joined:
    Nov 5, 2009
    Messages:
    296
    Likes Received:
    106
    Assassin - Have you had any luck?
     
  11. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    No, I have not had any success with it. I downloaded the program the other day and have tried to use it today.

    I have two lists. One has apx 65k and the other has 67k. The file increases by 3k each week and is sorted by zip code. With that said, the new entries are spread throughout the file so there is no simple way to get the information.

    Any help?