Community

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

    How to replace only in rows with a special text?

    General Discussion
    2
    3
    52
    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.
    • ErwinSchmidt17
      ErwinSchmidt17 last edited by

      Hello, I want to replace text but only in rows that have a special text. Example:

      file: image1_5000x5000.png, projectID: 1234
      file: image2_5000x5000.png, projectID: 5678
      file: image3_4000x4000.png, projectID: 1234

      Now I want to replace 5000x5000 with 45000x4500 but ONLY in the rows where I have the text “projectID: 1234”
      So after the replacement I have this:

      file: image1_4500x4500.png, projectID: 1234
      file: image2_5000x5000.png, projectID: 5678
      file: image3_4000x4000.png, projectID: 1234

      How can I do that?

      Ekopalypse 1 Reply Last reply Reply Quote 1
      • Ekopalypse
        Ekopalypse @ErwinSchmidt17 last edited by

        @ErwinSchmidt17

        given your example data you could do
        find what:5000x5000(?=.*?projectID: 1234)
        replace with:4500x4500
        having Regular expression checked.

        ErwinSchmidt17 1 Reply Last reply Reply Quote 2
        • ErwinSchmidt17
          ErwinSchmidt17 @Ekopalypse last edited by

          @Ekopalypse said in How to replace only in rows with a special text?:

          5000x5000(?=.*?projectID: 1234)

          Thank you. That worked.

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