UltraEdit, UltraCompare, UEStudio forums

That modification can be done with a Perl regular expression using backreferences with the search expression ( drop materialized view ) ( .* \r ? \n / \r ? \n ) (?! drop table ) and the replace expression \1 \2 drop table \2 .* matches any character except newline characters like carriage return or ...