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

How to sort this jumbled text file of keywords?

Discussion in 'Black Hat SEO Tools' started by GoogleAlchemist, Jul 17, 2011.

  1. GoogleAlchemist

    GoogleAlchemist Regular Member

    Joined:
    Nov 25, 2009
    Messages:
    249
    Likes Received:
    28
    Occupation:
    Bad Ass SEO Consultant
    Location:
    Wherever I want
    Home Page:
    Couldn't seem to find a better suited forum than this one...

    I have a text file that , I think, I got here from a friendly member containing God knows how many thousands of juicy keywords for using to scrape in scrapebox

    The thing is, when I open it up it is all jumbled together, they all run together, they are not line by line.

    How can I sort these so they are usable?

    Right now I open it up and it looks like this

    kw1 kw2 kw3 kw4 kw5 etc etc et

    I need to somehow get those to be

    kw1
    kw2
    kw2
    etc
    etc

    Im especially confused as to how to do this with multi word keyword phrases

    Thanks for any tips

    ps-I'm 'pretty sure' it was originally provided as a plain text file so it's not like I have a csv file or something and am trying to open it in a plain notepad when I should be opening it in excell so I'm stumped.
     
  2. madoctopus

    madoctopus Supreme Member

    Joined:
    Apr 4, 2010
    Messages:
    1,249
    Likes Received:
    3,498
    Occupation:
    Full time IM
    Maybe it is one per line but with Linux line endings. Open it in a proper code editor like Notepad++ and see if they are one per line. Normally if u open a Linux-style file in a windows program you get no line endings so all lines are concatenated.
     
  3. cyberzilla

    cyberzilla Elite Member Premium Member

    Joined:
    Nov 15, 2009
    Messages:
    2,204
    Likes Received:
    3,364
    Location:
    zeta reticuli
    You can try this if you have Office software. Copy and paste the data in an excel file. It will be saved in a single row. Follow the instructions given in this site..
    Code:
    http://office.microsoft.com/en-us/excel-help/rotate-data-by-converting-columns-to-rows-or-vice-versa-HP005203138.aspx
     
  4. peterlolz

    peterlolz Junior Member

    Joined:
    Jan 27, 2009
    Messages:
    135
    Likes Received:
    479
    You can download editpad pro best texteditor I know
    there you can replace " " with a new line (shift+enter to write newline)
     
  5. Jeeeens

    Jeeeens Registered Member

    Joined:
    Oct 7, 2010
    Messages:
    73
    Likes Received:
    4
    An option could be:

    1. Use the "Replace All function", which is to be found in most texteditors, and replace all spaces " " with <br>

    2. Save as a HTML fil or Copy/Paste it all into your HTML editor

    3. Open HTML file in your browser

    4. Copy List

    5. Insert in notepad
     
  6. unmark

    unmark Junior Member

    Joined:
    Jul 8, 2008
    Messages:
    139
    Likes Received:
    139
    Location:
    S 33° 51', E 151° 12'
    You can:
    1] Replace "white space" with a comma and save the file as a CSV file [comma delimited file].
    2] Open it again in Excel.
    3] Copy the row and paste it into a column.

    That should do the job.
     
  7. paincake

    paincake Power Member

    Joined:
    Aug 18, 2010
    Messages:
    716
    Likes Received:
    3,099
    Home Page:
    download notepad++

    CTRL+H
    check "regular expressions"
    in the find field write "\s" (without quotes) or just a space character
    in replace field write "\n"
    hit replace all

    problem solved