Regular expression in Notepad ++

Question

Can anyone provide a regular expression for notepad ++ for the below find and replace (transform)

ADD  ( PRIMARY KEY (xxx) ) ;

to

ADD  PRIMARY KEY (xxx) ;

basically removed a () around the primary key expression. the xxx value is different from the operators.

If not notepad ++, I can also try regex for vim or any shell script.

Many thanks. Woman.

+2

bsr Apr 13 10 at 18:52

3 answers

In perl, assuming you are reading a line at $ line

$line =~ s/([^(]+)\((.*)\)/$1$2/

will do the job. It also saves you the trouble of cutting the ADD PRIMARY KEY ... insert (with the right amount of spaces. The mode here is

a) Matching everything up to the first (and capturing it in $ 1

b) Compliance (

c) Matching all characters but not including the final) and capturing it at $ 2.

d) Compliance with the final)

e) Replace the original string with $ 1 $ 2.

0

Jasmeet Apr 14. 10 at 0:56

You don't need reg-ex. Find '( '

and replace with a space. Then search ') '

and replace nothing.

This '([space]'

and ')[space]'

.

-1

Michaelkay Apr 13 10 at 18:57

compie · Accepted Answer · 2010-04-13T19:05:16+0000

Search:

ADD  \( PRIMARY KEY \((.+)\) \) ;

Replaced by:

ADD  PRIMARY KEY (\1) ;