Community

Hi there, Im at the wits end trying to sort this out. I have an SQL doc, and I need to remove a bunch of statements beginning with INSERT INTO CONTACTLOG(.
I need to remove the entire line. Ive tried all different reg exp I could think of and none worked. Any one got any ideas?

If you're not very familiar with regular expressions, you can use the Mark All button on the Find dialog box, to put a bookmark on all lines containing matching text, then use Edit/Delete/Bookmarked Lines.

Alternatively, use the following regular expression with the Replace command:

Find what: ^INSERT INTO CONTACTLOG(.*\n

Set the Replace With box to nothing, then click Replace All.

Keith MacDonald
Helios Software Solutions