Find/Replace script not recognizing GREP removal of duplicated lines

[_jessmoe_]

I am modifying the "FindChangeByList" reference file to clean up a TV schedule. I've gotten everything to work so far except to remove the duplicate date lines.

I have the line highlighted in blue in my script, but it doesn't seem to do anything. When I enter those settings directly in the find/change GREP box it works fine. Just not when it's in the scrip. What am I missing?

For reference: I'm a total n00b at GREP and scripting so it's been a lot of google/copy/paste/trial/error. I'm attaching my unaltered schedule file and the "FindChangeList.txt" for reference.

[brian_p_dts]

Per the documentation for the script, you need to double escape bacsklashes: \\r and \\1

[_jessmoe_]

Unfortunately that didn't work. Funnily enough, I've used the single \ in other instances without issue. But changing everything to \\ doesn't make a difference.

[rob day]

Hi @_jessmoe_ , Try escaping \1, but not the return:

^(.+\r)\\1+

[_jessmoe_]

No luck there either.

[rob day · Accepted solution]

Works for me if I move the ^(.+\r)\\1+ search to first in the list and escape \1, so maybe the previous searches are affecting your ^(.+\r)\\1+ search. I’ve attached the text file.

[_jessmoe_]

That did it! Thank you!!

[Peter Kahrel]

Nice call, Rob. But how bizarre.

[rob day]

Hi Peter, If I run only the first 3 items before the remove duplicate lines in @_jessmoe_ ’s F&C list, there is a return left between the duplicate dates. Running the ^(.+\r)\1+ Grep code from the UI returns no match:

[Peter Kahrel]

That's caused by the second grep entry:

{changeTo:"~b$0"}

introduces a paragraph break (~b)