Results 1 to 5 of 5
  1. #1
    morgenmuffel
    Join Date
    Dec 2004
    Location
    Putaruru
    Posts
    2,877

    Default Replace a "comma space" with a new line in notepad++

    Ok

    I have a number of lists I am editing (to include in a spreadsheet) and they are in this form

    mlo46, hgdt75, hdsf6, fshdf765, 1245,...

    and i want to convert them into this form

    mlo46
    hgdt75
    hdsf6
    fshdf765
    1245
    ...


    Now back on my old windows 2k machine I used to be able to do this using a search and replace in a text editor, however since it died i haven't had occasion to do this

    I now need to and I cannot for the life of me remember how to do it

    My current text editor is notepad++ I also have pspad installed (although I have virtually never used it)

    any help would be greatly appreciated
    Morgenmuffel - This word needs to be a part of the english language, in fact you should use it in everyday conversation

  2. #2
    Junior Member
    Join Date
    Apr 2006
    Posts
    52

    Default Re: Replace a "comma space" with a new line in notepad++

    if you have got ms word you can use ^l in the replace with field.

  3. #3
    Senior Member
    Join Date
    Sep 2006
    Location
    Christchurch
    Posts
    116

    Default Re: Replace a "comma space" with a new line in notepad++

    yeah copy it all into ms word and use the replace tool to search for ", " and replace it with "^|"

  4. #4
    Misc. User of PressF1 somebody's Avatar
    Join Date
    Dec 2004
    Posts
    5,198

    Default Re: Replace a "comma space" with a new line in notepad++

    In Notepad++, using the "Replace" command, tick "Regular Expression", and use '\n' without the apostrophes for the Replace With.
    Any views expressed here are my own and do not necessarily represent the views of my employer or any affiliated 3rd party.

  5. #5
    morgenmuffel
    Join Date
    Dec 2004
    Location
    Putaruru
    Posts
    2,877

    Default Re: Replace a "comma space" with a new line in notepad++

    Thanks all

    Somebody - that works fine, I was trying the "Ctrl r" then "Ctrl M" but couldn't figure how to automate, your way is much simpler and dare I say embarrassingly obvious, i feel really daft not figuring that out.
    Morgenmuffel - This word needs to be a part of the english language, in fact you should use it in everyday conversation

Similar Threads

  1. Replies: 8
    Last Post: 05-10-2008, 03:34 PM
  2. Using "extended" partition space.
    By Timbo in forum PressF1
    Replies: 2
    Last Post: 15-09-2008, 12:05 PM
  3. Replies: 3
    Last Post: 19-08-2008, 08:43 PM
  4. Replies: 6
    Last Post: 18-02-2008, 12:43 PM
  5. Replies: 10
    Last Post: 07-12-2006, 09:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •