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

How to filter a CSV file with just 1 column?

Discussion in 'Black Hat SEO' started by wooSj, Feb 20, 2013.

  1. wooSj

    wooSj Junior Member

    Joined:
    Oct 6, 2010
    Messages:
    142
    Likes Received:
    60
    Location:
    Far away in space
    Hello,

    I was wondering, I have a CSV file which I want to split up. When I open it in Excel it opens all in column A, so can't filter it on a certain column. Now, I want to filter out the email addresses which all contain the @ which the other columns don't. Is it possible to filter those out in any way? Help would be appreciated.

    Thanks :)
     
  2. proweb

    proweb Regular Member

    Joined:
    Feb 24, 2011
    Messages:
    291
    Likes Received:
    144
    Do this:
    1) Highlight the column you want to sort
    2) Click on the "Data" tab
    3) Choose "Text to Columns"
    4) Click "Delimited" then "Next"
    5) Choose the separator you want to use
    6) Click next and finish

    This is for Excel only BTW.
     
    Last edited: Feb 20, 2013
  3. ReFanO

    ReFanO BANNED BANNED

    Joined:
    May 12, 2011
    Messages:
    124
    Likes Received:
    28
    Create a database using php or any other programing language. You can get one field to emails.