Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

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

    Help wanted · · · – – – · · ·
    2
    4
    170
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Robert Long 0
      Robert Long 0 last edited by

      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

      1 Reply Last reply Reply Quote 0
      • PeterJones
        PeterJones last edited by

        • 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.

        Robert Long 0 1 Reply Last reply Reply Quote 3
        • Robert Long 0
          Robert Long 0 last edited by

          This post is deleted!
          1 Reply Last reply Reply Quote 0
          • Robert Long 0
            Robert Long 0 @PeterJones last edited by

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

            Thank you for the quick reply

            1 Reply Last reply Reply Quote 2
            • First post
              Last post
            Copyright © 2014 NodeBB Forums | Contributors