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

Help please :D

Discussion in 'FaceBook' started by Em][n3m, Dec 27, 2011.

  1. Em][n3m

    Em][n3m Power Member

    Joined:
    Dec 8, 2010
    Messages:
    558
    Likes Received:
    145
    Occupation:
    Student
    Location:
    City of Lost Heaven
    hey , i have one question . I have a bunch of emails in a .txt in this format :

    junebass59@yahoo.com,June,Bass,[url]http://www.facebook.com/profile.php?id=100000557371449[/url]
    junebee72@aol.com,Barbara,June,[url]http://www.facebook.com/profile.php?id=100000586424265[/url]
    junebeezy1@yahoo.com,June,Antwine,[url]http://www.facebook.com/profile.php?id=1673739163[/url]
    junebell1002000@yahoo.com,Connie,Gibson,[url]http://www.facebook.com/profile.php?id=1180670452[/url]

    how can i clean this txt file so i can keep only email so everything after first comma is deleted ?

    i tried notepad++ but couldnt find any answer :(
     
  2. maxbond

    maxbond Newbie

    Joined:
    Aug 15, 2009
    Messages:
    7
    Likes Received:
    1
    1. save as csv file.
    2. open with excel
    3. Delete all the column that you do not want.
    4. Save.
    Walah, you cleaned it up.
     
    • Thanks Thanks x 1
  3. Em][n3m

    Em][n3m Power Member

    Joined:
    Dec 8, 2010
    Messages:
    558
    Likes Received:
    145
    Occupation:
    Student
    Location:
    City of Lost Heaven
    lol , im such and idiot :)) i forgot excel has comma delimited format. thank you so much maxbond