Community
    • Login

    Conditional replacing

    Scheduled Pinned Locked Moved Help wanted · · · – – – · · ·
    2 Posts 2 Posters 2.3k Views 2 Watching
    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.
    • Mario Enrique Martínez DuránM Offline
      Mario Enrique Martínez Durán
      last edited by

      Hello everyone!

      I have a .txt file separated with commas (,). In some cases, there is a field containing data like “7,5 cm”, making an extra field. How can i replace the commas with dots to avoid extra fields, but don’t replacing the separators?

      Thank you!

      Claudia FrankC 1 Reply Last reply Reply Quote 0
      • Claudia FrankC Offline
        Claudia Frank @Mario Enrique Martínez Durán
        last edited by

        @Mario-Enrique-Martínez-Durán

        by using a regular express like

        find what:(\d+)(,)(\d+)
        replace width: $1\.$3
        

        Means it is looking for any number of digits followed by a comma and again digits

        To find out more about regular expression I would recommend reading
        nearly every post by @guy038 and the regex engines details as described here. In addition sites like http://www.rexegg.com/ and https://regex101.com/
        are useful too.

        Cheers
        Claudia

        1 Reply Last reply Reply Quote 0

        Hello! It looks like you're interested in this conversation, but you don't have an account yet.

        Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

        With your input, this post could be even better 💗

        Register Login
        • First post
          Last post
        The Community of users of the Notepad++ text editor.
        Powered by NodeBB | Contributors