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

Convert Row Into Comma Separated List?

Discussion in 'Black Hat SEO' started by Krazy Kitty, May 6, 2010.

  1. Krazy Kitty

    Krazy Kitty Regular Member

    Joined:
    Feb 11, 2008
    Messages:
    374
    Likes Received:
    154
    Occupation:
    Webmistress
    Location:
    Originally, U.S of A.
    If I have the following list of keywords:

    cat foot
    good cat foot
    tasty cat foot

    How can I easily convert it into a comma separated text file like this:

    cat foot, good cat foot, tasty cat foot

    Any bright ideas?
     
    • Thanks Thanks x 1
  2. jodys

    jodys BANNED BANNED

    Joined:
    Feb 10, 2010
    Messages:
    174
    Likes Received:
    131
    Excel, copy list to clipboard, click cell A1, paste, save as csv file.
     
    • Thanks Thanks x 1
  3. Krazy Kitty

    Krazy Kitty Regular Member

    Joined:
    Feb 11, 2008
    Messages:
    374
    Likes Received:
    154
    Occupation:
    Webmistress
    Location:
    Originally, U.S of A.
    I'm using open office. I can't get it to work like that.
     
  4. Choronzon

    Choronzon Power Member

    Joined:
    Apr 20, 2008
    Messages:
    559
    Likes Received:
    376
    PM it to me and I'll convert it and send it back
     
  5. Krazy Kitty

    Krazy Kitty Regular Member

    Joined:
    Feb 11, 2008
    Messages:
    374
    Likes Received:
    154
    Occupation:
    Webmistress
    Location:
    Originally, U.S of A.
    I appreciate the offer, Choronzon. That's very kind of you. But this is something I will need to do a lot. I do it every day by hand. I was just wondering if there was an easier way to save me some time.
     
  6. jodys

    jodys BANNED BANNED

    Joined:
    Feb 10, 2010
    Messages:
    174
    Likes Received:
    131
    You can do it in ooCalc - here's a tutorial

    http://sheepdogguides.com/fdb/opof8csv.htm
     
  7. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    Great question and I'm glad I have the solution (and then some).

    1. Download ASAP Utilities (is a free Excel add-in that you will love and be willing to give money too... trust me)
    2. Once you have it installed, open Excel. You will notice the AddIn 'ASAP Utilities'. If you do not see it, open it via the Start > Programs...
    3. With your range selected, and with ASAP open, click on Fill > Insert After Current Value, and then in the box, type the comma.

    This approach will add a comma at the end of every row/final word.

    There may be an easier way to do this but once you open ASAP Utilities and see what all it can do, you will be hooked. I use it many times a day every day and best of all, it is FREE.

    ---http://www.asap-utilities.com/

    I hope that helps you and others.
     
  8. Choronzon

    Choronzon Power Member

    Joined:
    Apr 20, 2008
    Messages:
    559
    Likes Received:
    376
    I wrote a free program for managing email lists but one of the things it does is loads a list of email addresses (or words LOL) and then saves it out as a csv list. You can take a look here http://www.themeetingjunction.com/lister.html
     
    • Thanks Thanks x 1
  9. yesrams

    yesrams Regular Member

    Joined:
    Dec 16, 2009
    Messages:
    354
    Likes Received:
    75
    Location:
    @BHW
    copy all keywords in Micr0s0ft w0rd.
    Select Edit>Replace
    It opend Find and Replace Dialog box
    give find what as : ^p (press shift key+6 for this ^ and use small p)
    give Replace with as : , (Comma)
    click on Replace all

    Thats it
     
    • Thanks Thanks x 8
  10. Velvet

    Velvet Junior Member

    Joined:
    Feb 18, 2009
    Messages:
    199
    Likes Received:
    146
    the most easiest way is to use this free tool:

    Code:
    http://www.jumbokeyword.com
    can do 70+ actions with your keywords
     
  11. Ibeefaaa

    Ibeefaaa Regular Member

    Joined:
    Apr 24, 2010
    Messages:
    365
    Likes Received:
    683
    Occupation:
    Part time IM and part time unemployed :))
    Location:
    Chasing the Smoosh !

    I was looking for something like that too.

    Your method is working very well and it's simple.
    Thanks
     
  12. lionofjudhaa

    lionofjudhaa Newbie

    Joined:
    Jan 19, 2010
    Messages:
    7
    Likes Received:
    0
    Gender:
    Male
    Thank you
     
  13. masterfl

    masterfl Junior Member

    Joined:
    Apr 28, 2010
    Messages:
    160
    Likes Received:
    29
    Occupation:
    Fulltime Web Developer, Newbie IM
    Location:
    Philippines
    Home Page:
    another method which I use is to get a program that has a macro feature (i use ultraedit)

    then go to the menu -> record macro

    and then you can use a macro like 'press the end button' -> 'press the , button' -> 'press space (optional)' -> 'press delete (so the second line will be on the first line too)'

    then save this macro and run it xx times or just select until end of file (sometimes that feature is unreliable so i prefer to run it xx times) (Macro Menu -> Play Any/Multiple Times)

    this method is great for converting any text that has a format to another format
     
  14. Chronos

    Chronos Junior Member

    Joined:
    May 5, 2010
    Messages:
    126
    Likes Received:
    294
  15. Joslo

    Joslo Registered Member

    Joined:
    Oct 18, 2007
    Messages:
    57
    Likes Received:
    12
    Download openoffice it's free and has almost all the features of microsoft office then open scalc it's like excel insert the values into the cells and save as a csv you will be asked if you want to save with the values like " and , say yes and that's it you got a csv file.
     
  16. john14809

    john14809 Junior Member

    Joined:
    Jan 3, 2008
    Messages:
    140
    Likes Received:
    77
    I have been using this method for a while and it works great.
     
  17. maxxtuner

    maxxtuner Junior Member

    Joined:
    Sep 3, 2009
    Messages:
    110
    Likes Received:
    32
    www.jumbokeyword.com works for every sorting replacing editing task you will ever have, and is free and browser base no download or install.
     
  18. Charles27

    Charles27 Registered Member

    Joined:
    Nov 3, 2011
    Messages:
    99
    Likes Received:
    10
    Occupation:
    IM
    Location:
    Pennsylvania
    try this "optimisation" [add "dot asia" on end]