how to convert carriage return to comma separated for keyword list?

Discussion in 'White Hat SEO' started by donjuan, Dec 24, 2009.

  1. donjuan

    donjuan Power Member

    Joined:
    Oct 12, 2007
    Messages:
    542
    Likes Received:
    236
    Location:
    ..the dark side
    hey guys need some help I would like to convert a keyword list from individual line items to comma separated or | (pipe) separated without having to use excel since I have no clue how to really use it with macros and all that jazz.
    usually i do this by hand but this list is way too long.thx
     
  2. Hellfire

    Hellfire Regular Member

    Joined:
    Jun 27, 2009
    Messages:
    241
    Likes Received:
    150
    Occupation:
    Student
    Location:
    Norway
    Open word -> ctrl+f -> replace -> replace "|" with "," -> replace all
     
    • Thanks Thanks x 2
  3. kalatopi

    kalatopi Newbie

    Joined:
    Aug 3, 2008
    Messages:
    49
    Likes Received:
    29
    Open Word -> Ctrl+h -> replace "^p" (CRLF) with ", " (comma space) -> replace all.

    Remove commas at the end if any.
     
    • Thanks Thanks x 2
  4. donjuan

    donjuan Power Member

    Joined:
    Oct 12, 2007
    Messages:
    542
    Likes Received:
    236
    Location:
    ..the dark side
    Yea I figured it out using notepad++ using reg expressions.
     
  5. kalatopi

    kalatopi Newbie

    Joined:
    Aug 3, 2008
    Messages:
    49
    Likes Received:
    29
    Yes, Textpad is another tool like Notepad++ that speeds this up.