Shell Programming and Scripting

I have a big perl script need to fix a small pattern matching inside ..
I have patterns like

create unique index
create index

The pattern matching should look for both the pattern in the same statement, The existing matching looks for only "create unique index"
The exising code for this i have is

Code:

/^create\s+.+\s+index\s+.+\s+on\s+(\w+)/

How do i can modify to look for "create index" also.

I see two patterns, create index and create unique index

But the regular expression includes the word on

I don't understand. Neither of the patterns has the word on so how could they match?

Could you please give the complete lines you want to match against?

yes it is create index /create unique index statement of oracle.
This script parse the input sql file(which has all table,index.. creation statements to setup a schema).

This script not parsing the statement "create index....." , it parse only "create unique index ...." I need to fix in this single statement itself to parse both the statements.

It would be better if you could post some complete lines. But no matter.

create index has one space.
create unique index has two spaces.

Your regular expression specifies at least two spaces between create and index. Each \s+ means "one or more spaces". So that is at least two. So the RE does not match create index

Try something like /^create\s+.*index\s+.+\s+on\s+(\w+)/

You perhaps may have the same problem between index and on

Does your file have tabs? If not, just use a space instead of the confusing \s syntax.

/^create +.*index +.+ +on +(\w+)/

Code:

/^create +.*index +.+ +on +(\w+)/

The second solution worked ..
First gave error

More precise is

Code:

/^create\s+(\w+\s+)?index\s+.+\s+on\s+(\w+)/

'create' space, potentially followed by word space, followed by 'index'
Instead of allowing any word \w+you can put unique.
NB a $1 in the following perl code must be changed to $2, so it still refers to the now 2nd ( ).

Maybe you could post the input lines, the regular expression you used, and the error you saw.