CODEWITHSUNDEEP
regexnotepad++newlinemultilinetextpad
snowrock
snowrock

Reputation: 181

regular expression search in notepad++ or text pad

I want to be able to search a pattern like 'CREATE TABLE ' followed by any expression include newline and ending with );

So it should be able to select following 2 create table stamtement one after other. 

create table tab1 ( col1 number,

col2 date);

create table tab3 ( col1 number,

col2 date,

col3 number);

I did tried create table .* but I am not able to include newline .

Thanks.

Upvotes: 0

Views: 356

Answers (1)

Kent
Kent

Reputation: 195049

this should do:

create table [^;]*;

check the matches newline checkbox

Upvotes: 1

Related Questions