Hi, @jizhao-li, @coises, @mark-olson and All,
Ah… OK. Thanks, @jizhao-li, for your additional pieces of information :-)
Then, from this INPUT text, below :
GAP 1461 311 1826 311 2191 311 2556 311 2921 311 3287 311 3652 311 4017 311 4382 311 4748 311 5113 311 5478 311 5843 311 6209 311 6574 311 6939 311 7304 311 7670 311 8035 311 8400 311 8765 311 9131 311 9496 311 9861 311 10026 311 10592 311 10957 311 11322 311 11687 311 12053 311 12418 311 12783 308 13148 308 13514 308 13789 308 END GAP 1461 303 1826 303 2191 303 2556 303 2921 303 3287 303 3652 303 4017 303 4382 303 4748 303 5113 303 5478 303 5843 303 6209 303 6574 303 6939 303 7304 303 7670 303 8035 303 8400 303 8765 303 9131 303 9496 303 9861 303 10026 303 10592 303 10957 303 11322 303 11687 303 12053 303 12418 303 12783 303 13148 303 13514 303 13789 303 END GAP 1461 327.5 1826 327.5 2191 327.5 2556 327.5 2921 327.5 3287 327.5 3652 327.5 4017 327.5 4382 327.5 4748 327.5 5113 327.5 5478 327.5 5843 327.5 6209 327.5 6574 327.5 6939 327.5 7304 327.5 7670 327.5 8035 327.5 8400 327.5 8765 327.5 9131 327.5 9496 327.5 9861 327.5 10026 327.5 10592 327.5 10957 327.5 11322 327.5 11687 327.5 12053 327.5 12418 327.5 12783 327.5 13148 327.5 13514 327.5 13789 327.5 END GAP 1461 302 1826 302 2191 299 2556 299 2921 299 3287 299 3652 299 4017 299 4382 299 4748 299 5113 299 5478 299 5843 299 6209 302 6574 302 6939 302 7304 302 7670 302 8035 302 8400 302 8765 302 9131 302 9496 302 9861 302 10026 302 10592 302 10957 302 11322 302 11687 302 12053 302 12418 302 12783 302 13148 302 13514 302 13789 302 ENDThe following regex S/R should do the work nicely :
SEARCH (?-is)^(GAP\R)(\d+ (\d+(?:\.\d+)?)\R)+?(?=\d+ (?!\3$))
REPLACE \1\2
And here is your expected OUTPUT text :
GAP 12418 311 12783 308 13148 308 13514 308 13789 308 END GAP 1461 303 1826 303 2191 303 2556 303 2921 303 3287 303 3652 303 4017 303 4382 303 4748 303 5113 303 5478 303 5843 303 6209 303 6574 303 6939 303 7304 303 7670 303 8035 303 8400 303 8765 303 9131 303 9496 303 9861 303 10026 303 10592 303 10957 303 11322 303 11687 303 12053 303 12418 303 12783 303 13148 303 13514 303 13789 303 END GAP 1461 327.5 1826 327.5 2191 327.5 2556 327.5 2921 327.5 3287 327.5 3652 327.5 4017 327.5 4382 327.5 4748 327.5 5113 327.5 5478 327.5 5843 327.5 6209 327.5 6574 327.5 6939 327.5 7304 327.5 7670 327.5 8035 327.5 8400 327.5 8765 327.5 9131 327.5 9496 327.5 9861 327.5 10026 327.5 10592 327.5 10957 327.5 11322 327.5 11687 327.5 12053 327.5 12418 327.5 12783 327.5 13148 327.5 13514 327.5 13789 327.5 END GAP 1826 302 2191 299 2556 299 2921 299 3287 299 3652 299 4017 299 4382 299 4748 299 5113 299 5478 299 5843 299 6209 302 6574 302 6939 302 7304 302 7670 302 8035 302 8400 302 8765 302 9131 302 9496 302 9861 302 10026 302 10592 302 10957 302 11322 302 11687 302 12053 302 12418 302 12783 302 13148 302 13514 302 13789 302 ENDSome other tests, all OK ! On the left the INPUT text and on the right the OUTPUT text :
GAP 4017 123 4382 123 GAP 4748 123 5478 123 5113 123 5843 456 5478 123 6209 456 5843 456 => 6574 456 6209 456 6939 456 6574 456 7304 456 6939 456 END 7304 456 END GAP 4017 123 4382 123 GAP 4748 123 5478 123 5113 123 5843 456.789 5478 123 6209 456.789 5843 456.789 => 6574 456.789 6209 456.789 6939 456.789 6574 456.789 7304 456.789 6939 456.789 END 7304 456.789 END GAP 4017 123 4382 123 GAP 4748 123 5478 123 5113 123 5843 123.789 5478 123 6209 123.789 5843 123.789 => 6574 123.789 6209 123.789 6939 123.789 6574 123.789 7304 123.789 6939 123.789 END 7304 123.789 END GAP 4017 123.012 4382 123.012 GAP 4748 123.012 5478 123.012 5113 123.012 5843 456 5478 123.012 => 6209 456 5843 456 6574 456 6209 456 6939 456 6574 456 7304 456 6939 456 END 7304 456 END GAP 4017 123.012 4382 123.012 GAP 4748 123.012 5478 123.012 5113 123.012 5843 123 5478 123.012 => 6209 123 5843 123 6574 123 6209 123 6939 123 6574 123 7304 123 6939 123 END 7304 123 END GAP 4017 123.012 4382 123.012 GAP 4748 123.012 5478 123.012 5113 123.012 5843 456.789 5478 123.012 6209 456.789 5843 456.789 => 6574 456.789 6209 456.789 6939 456.789 6574 456.789 7304 456.789 6939 456.789 END 7304 456.789 END GAP 4017 123 GAP 4382 123 4748 123 4748 123 5113 456 5113 456 5478 456 5478 456 5843 456 5843 456 => 6209 456 6209 456 6574 123 6574 123 6939 123 6939 123 7304 123 7304 123 END END GAP 4017 123.012 GAP 4382 123.012 4748 123.012 4748 123.012 5113 456.789 5113 456.789 5478 456.789 5478 456.789 5843 456.789 5843 456.789 => 6209 456.789 6209 456.789 6574 123.012 6574 123.012 6939 123.012 6939 123.012 7304 123.012 7304 123.012 END ENDNote that your file will be unchanged if you redo the search-replacement !!
Best Regards,
guy038