Community

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

    How To Delete Specific String In Macro Recorder

    General Discussion
    2
    6
    638
    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.
    • Anthony Jocius
      Anthony Jocius last edited by

      I have very large text files which have all sorts of unwanted data. The data must be parsed to remove most of the unwanted text. I haven’t been able to write a “Search And Replace” which will cut some of this unwanted data. Would someone be so kind to show me how I can eliminate the unwanted text. Note the text preceding the “,Done” can be almost any name. So there needs to be a wildcard.

      Change From:
      ,Profile,Production,Cycle,Normal,PMVer,14.0.1.103,SeqFileVer,1.8.0.0,User,0000007456112,Station,TS-0457A,Socket,0,Date,04-17-2019,Time,13:11:09,CycleTime,722.903,Status,Passed,MAC_Address,F8DC7A205018,CycleTimes,Done,DEBUG_PRODUCTION_FALSE,…

      Change To:
      ,Profile,Production,Cycle,Normal,PMVer,14.0.1.103,SeqFileVer,1.8.0.0,User,0000007456112,Station,TS-0457A,Socket,0,Date,04-17-2019,Time,13:11:09,CycleTime,722.903,Status,Passed,MAC_Address,F8DC7A205018,DEBUG_PRODUCTION_FALSE,…

      What was removed:
      CycleTimes,Done,

      Alan Kilborn 1 Reply Last reply Reply Quote 1
      • Alan Kilborn
        Alan Kilborn @Anthony Jocius last edited by

        @Anthony-Jocius

        There must be more to the story as a simple replacement of CycleTimes,Done, with nothing seems to do the job…?

        1 Reply Last reply Reply Quote 0
        • Anthony Jocius
          Anthony Jocius last edited by

          The part of the string “CycleTimes” can be any text. That is the whole story. I’m new to Notepad++ and am trying to use it more efficiently.

          Alan Kilborn 1 Reply Last reply Reply Quote 1
          • Alan Kilborn
            Alan Kilborn @Anthony Jocius last edited by Alan Kilborn

            I’d be tempted to try:

            Find: ,[^,]+,Done
            Replace: nothing
            Search mode: Regular expression

            The “funky part”, the [^,]+ means “one or more characters that aren’t comma”.

            1 Reply Last reply Reply Quote 1
            • Anthony Jocius
              Anthony Jocius last edited by

              Amazing. It works like a champ. Thank you for giving the pathway to much smaller text files. Thank you, sir.

              Alan Kilborn 1 Reply Last reply Reply Quote 2
              • Alan Kilborn
                Alan Kilborn @Anthony Jocius last edited by

                @Anthony-Jocius

                Amazing…

                Check out this link and the things it links to in order to really understand the magic. :)

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