Community
    • Login

    How to locate text separators and replace them?

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    21 Posts 7 Posters 10.8k Views
    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.
    • Patrick ChatelleP
      Patrick Chatelle
      last edited by Patrick Chatelle

      This seemed like it should be top of list, but here goes

      I need to replace comma “,” with a pipe “|”, but only if a comma immediately follow a 2 digit decimal.

      So
      ,49.30,49.30,.00,.00,.00,
      needs to be
      |49.30|49.30|.00|.00|.00|

      notepad++ (Regular expression radio button clicked)
      in the “Find what:” box -> (?:[.\d\d]{0},)
      in the “Replace with:” box -> |

      add “\d” for more decimals.

      1 Reply Last reply Reply Quote 0
      • First post
        Last post
      The Community of users of the Notepad++ text editor.
      Powered by NodeBB | Contributors