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

[WTB] script that compares 2 files and creates 3 without duplicate emails (small budget)

Discussion in 'Hire a Freelancer' started by XoRaK, Jul 3, 2014.

  1. XoRaK

    XoRaK Regular Member

    Joined:
    Oct 28, 2009
    Messages:
    303
    Likes Received:
    250
    Occupation:
    social worker
    Location:
    Belgium
    Hi

    I have 2 .csv files

    both files are in the following form:

    FILE1.CSV

    EMAIL1,TEXT,TEXT
    EMAIL2,TEXT,TEXT
    EMAIL3,TEXT,TEXT
    EMAIL4,TEXT,TEXT

    FILE2.CSV

    EMAIL1,TEXT,TEXT
    EMAIL2,TEXT,TEXT
    EMAIL6,TEXT,TEXT
    EMAIL7,TEXT,TEXT

    The script should create a third file with the following output

    FILE3.CSV

    EMAIL6,TEXT,TEXT
    EMAIL7,TEXT,TEXT

    So it takes FILE2.CSV compares it with FILE1.CSV and creates FILE3.CSV without the duplicate emails.

    Greetz

    Nick
     
  2. Techxan

    Techxan Elite Member

    Joined:
    Dec 7, 2011
    Messages:
    3,093
    Likes Received:
    3,585
    Occupation:
    Local SEOist
    Location:
    TEXAS (you have to yell, its the law.)
    Stick the files into excel, merge them, go to data, and select "remove duplicates", if you have Office 2007 or 2010.
     
    • Thanks Thanks x 1
  3. handmadebots

    handmadebots Senior Member

    Joined:
    Nov 8, 2012
    Messages:
    902
    Likes Received:
    204
    Home Page:
    I can help you out.
     
  4. manishseth

    manishseth Junior Member

    Joined:
    Apr 29, 2014
    Messages:
    147
    Likes Received:
    37
    Location:
    New Delhi, India
    Excel can do the task quickly and freely.
     
  5. redrubies

    redrubies Supreme Member

    Joined:
    Jan 17, 2011
    Messages:
    1,424
    Likes Received:
    2,560
    Location:
    USA
    Oh, oh, oh! I needed to know how to do this too. Thank God you're on my friends list and I can see your posts. LOL
     
    • Thanks Thanks x 2
  6. provision

    provision Jr. VIP Jr. VIP Premium Member

    Joined:
    Oct 27, 2013
    Messages:
    406
    Likes Received:
    208
    LOL @redrubbies another helpful site if you don't have excel that can do almost anything for text related for free and simply is

    http://textmechanic.com/
     
    • Thanks Thanks x 2
  7. redrubies

    redrubies Supreme Member

    Joined:
    Jan 17, 2011
    Messages:
    1,424
    Likes Received:
    2,560
    Location:
    USA
    Thank you provision! That's a really good site. I bookmarked it and will be using it.
     
  8. rishcosys

    rishcosys Power Member

    Joined:
    Apr 16, 2014
    Messages:
    577
    Likes Received:
    14
    Gender:
    Male
    Occupation:
    IT engineers
    Location:
    Delhi, India
    PM Sent contact on skype
     
  9. sohom

    sohom Senior Member

    Joined:
    May 26, 2013
    Messages:
    981
    Likes Received:
    175
    Location:
    not in Past
    hope above members , help you out already
    if you are still looking for app, then you can PM me :)
    thanks
     
  10. dekadent30

    dekadent30 Power Member

    Joined:
    Nov 10, 2008
    Messages:
    516
    Likes Received:
    144
    You can use scrapebox dup keywords remove