Search code examples
regexnotepad++newlinemultilinetextpad

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.

Solution

  • this should do:

    create table [^;]*;

    check the matches newline checkbox