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?
Help with removing entire lines.
Moderators: AmigoJack, bbadmin, helios, Bob Hansen, MudGuard
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
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