Community

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

    remove string after a limiter

    Help wanted · · · – – – · · ·
    4
    6
    153
    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.
    • Clyde Parker
      Clyde Parker last edited by

      Hello everyone, so i wanted to clear a list which has a limiter " || " already tried experimenting with some regex
      here’s an example of the content in the files
      client@mail.com:orderID || Payment Date
      So what i’m trying to do is remove " || Payment Date " with regex, i can’t just replace the string because everyline would have a different date. all i can do is use the " || " as reference because it constant
      thank you!

      Alan Kilborn astrosofista 2 Replies Last reply Reply Quote 0
      • Alan Kilborn
        Alan Kilborn @Clyde Parker last edited by

        @Clyde-Parker

        find: (?-s)\|\|.+
        repl: nothing

        1 Reply Last reply Reply Quote 4
        • Clyde Parker
          Clyde Parker last edited by

          Works like charm, tysm

          1 Reply Last reply Reply Quote 0
          • astrosofista
            astrosofista @Clyde Parker last edited by astrosofista

            Hi @Clyde-Parker

            Please try this regex,

            Search: (?-s)^.+?\K\Q ||\E.+$
            Replace: [leave empty]
            

            Put the caret at the very beginning of the file, select just the Regular Expressions mode and click on Replace All.

            Take care and have fun!

            Edit: Alan beat me!

            1 Reply Last reply Reply Quote 4
            • guy038
              guy038 last edited by guy038

              Hi, @clyde-parker, @alan-kilborn, @astrosofista and All,

              Alan beat me too. Moreover, with exactly the same regex :-)


              @clyde-parker, this search regex is quite obvious !

              Notes :

              • First the (?-s) is an in-line modifier which forces the regex engine to see any meta-character . as matching a single standard char ( so not the EOL characters )

              • Then the part \|\| represents two literal pipe characters. They must be escaped as | is the meta-character for defining alternatives

              • Finally, the part .+ matches for any non-empty range of standard characters …till the end of current line, so any existing Payment Date

              • The overall match ||Payment Date, is simply deleted as the replacement zone is empty


              To learn how to build regular expressions, I strongly advice you to carefully read this FAQ. It should not be difficult to master the basic concepts, in a week or so ;-))

              Best Regards,

              guy038

              Alan Kilborn 1 Reply Last reply Reply Quote 3
              • Alan Kilborn
                Alan Kilborn @guy038 last edited by

                @guy038 said in remove string after a limiter:

                Alan beat me too. Moreover, with exactly the same regex :-)

                Haha, well does this show that some of us are learning?
                See, it can happen, people!

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