- AuthorPosts
- December 14, 2006 at 3:38 pm #4057abgibbsMember
Hello all,
Fist off — great editor! Best I’ve ever used, by a long shot.
I need to remove all lines beginning with “IF EXISTS” from a couple thousand .SQL files, but I’m confused on how the “find in files” box handles regex.
I *should* use:
Find: IFs{1}EXISTS.+n
replace:However, it doesn’t find any matches when I do this. if I remove the n from the “find” regex it finds all the corret matches but doesn’t include the CRLF at the end of the line. I want to remove the entire line, including the CRLF. Is there something weird about how the “find in files” handles end-of-line characters?
Thanks!
December 15, 2006 at 3:27 am #4062Yutaka EmuraKeymasterThe regular expression is correct if the Keep Modified Files Open is on. However, if the Keep Modified Files Open is off, you must use /r/n for a new line. So the regular expression should be
IFs{1}EXISTS.+rn
(if the Keep Modified Files Open is off in the Replace in Files dialog box).
See Also How to Specify New Lines
- AuthorPosts
- You must be logged in to reply to this topic.