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

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:
    539
    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:
    539
    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.