Regular Expression – Lazy Search

The following examples are in notepad++.

 

Lazy Search .*?

 

Example:

I would like to search the table name.

Text

INSERT INTO TESTING_TABLE1 (CODE, VALUE) VALUES ('1', 'A');
INSERT INTO TESTING_TABLE2 (CODE, VALUE) VALUES ('2', 'B');
INSERT INTO TESTING_TABLE3 (CODE, VALUE) VALUES ('3', 'C');

Replace

Find what: INSERT INTO (.*?) \(.*
Replace with: \1

Result:

TESTING_TABLE1
TESTING_TABLE2
TESTING_TABLE3