Community

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

    Conditional replacing

    Help wanted · · · – – – · · ·
    2
    2
    1817
    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án
      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 Frank 1 Reply Last reply Reply Quote 0
      • Claudia Frank
        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
        • First post
          Last post
        Copyright © 2014 NodeBB Forums | Contributors