How to Find all comma and replace it with a Hard Return (HRT)



  • Hi,
    I have a single line txt file with

    Robert Long robert.long@xxxx.com, Michael Long m.long@xxxx.com, . . . .

    What I want to do is have a hard return at each comma (removing the comma if possible)

    Thank you



    • FIND = “,\h*”
    • REPLACE = “\r\n”
    • Search Mode = regular expression
    • REPLACE ALL

    ----

    Do you want regex search/replace help? Then please be patient and polite, show some effort, and be willing to learn; answer questions and requests for clarification that are made of you. All example text should be marked as plain text using the </> toolbar button or manual Markdown syntax; screenshots can be pasted from the clipbpard to your post using Ctrl+V. Show the data you have and the text you want to get from that data; include examples of things that should match and be transformed, and things that don’t match and should be left alone; show edge cases and make sure you examples are as varied as your real data. Show the regex you already tried, and why you thought it should work; tell us what’s wrong with what you do get… Read the official NPP Searching / Regex docs and the forum’s Regular Expression FAQ. If you follow these guidelines, you’re much more likely to get helpful replies that solve your problem in the shortest number of tries.



  • This post is deleted!


  • @PeterJones Awesome! Thank you
    I forgot to do Regular Expression

    Thank you for the quick reply


Log in to reply