How To Delete Specific String In Macro Recorder

[Anthony Jocius]

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]

@Anthony-Jocius

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

[Anthony Jocius]

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]

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”.

[Anthony Jocius]

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

[Alan Kilborn]

@Anthony-Jocius

Amazing…

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