Regular expression that parses an SQLLite create index statement

I need a regular expression that can parse an SQLLite create index statement. In the following SQLite create table & index statements:

CREATE TABLE [Table 1] ([Column With Space] INT, ColumnWithoutSpace INT, Column3 INT);

CREATE INDEX IndexOne on [Table 1] ([Column With Space] collate nocase DESC, ColumnWithoutSpace, Column3);

CREATE INDEX IndexTwo on [Table 1] (Column3 ASC);

CREATE INDEX IndexTree on [Table 1] ([Column With Space] ASC, Column3 collate NOCASE);

Only the create index statements need to have a regular expression applied. The regular expression needs to find the following:

1. The table name that the index is being created on.

2. For EVERY column specified in the index:

2a. The column name

2b. The column collation (if specified)

2c. The column sort mode (if specified).

The resulting regex must work with the C# [url removed, login to view] method._

Skills: Anything Goes, Script Install, Shell Script, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: regular expression no, regular expression in c, regular expression c, regular expression a, regular expression 0, regex is, regular, Expression, parse expression, parse table, regular create, table parse, index is, Method Statement, collation work, table create script, create statement, create find script, sqllite, create table

About the Employer:
( 45 reviews ) Hubley, Canada

Project ID: #2748347

1 freelancer is bidding on average $12 for this job


See private message.

$12 USD in 5 days
(126 Reviews)