Regex parse sql string

Question

I have sql string like

select * from dbo.Person where Person  = ? AND Name = ? OR (Country = ? OR City = 1)

If it's possible to get string array like below with Regex in C#

result[0] = Person = ?
result[1] = Name = ?
result[2] = (Country = ? OR City = 1)

thanks.

what you mean by from dbo.Person where Person is person is table name as well as column name? — sujith karivelil
– sujith karivelil, Commented Jan 22, 2016 at 12:16
Is this necessary for a real world application? If so, in my humble opinion, it shouldn't.. — Soner Gönül
– Soner Gönül, Commented Jan 22, 2016 at 12:18
Yes It is Possible so for you make the regex and for that you use Regex.Matches(string, regex) . — KARAN
– KARAN, Commented Jan 22, 2016 at 12:19

blogprogramisty.net · Accepted Answer · 2016-01-22 12:52:13Z

1

First try looks like this

var s = @"select* from dbo.Person where Person = ? AND Name = ? OR (Country = ? OR City = 1)";

 var reg = new Regex("[A-Za-z]+ = [A-Za-z0-9?]+");

var result =  reg.Matches(s);

Something like that but is no Regex

  var s = @"select* from dbo.Person where Person = ? AND Name = ? OR(Country = ? OR City = 1)";

  var s1 = s.Split(new[] { "where" }, StringSplitOptions.None)[1];

  var s2 = s1.Split(new[] { "OR", "AND" }, StringSplitOptions.None);

edited Jan 22, 2016 at 12:52

answered Jan 22, 2016 at 12:26

blogprogramisty.net

1,7921 gold badge20 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2705585 Over a year ago

You regex doesn't match result[2] = (Country = ? OR City = 1) as one match. It matches Country = ? and City = 1 as two different matches.

Community · Accepted Answer · 2017-05-23 12:15:19Z

1

If you need anything more complicated than this, it's going to quickly go beyond what you can easily solve with regex. I have released a free parser on GitHub that will parse out TSQL in a stable way into the pieces, TSQL Parser . You can also use the Microsoft TSQL parser, using the TSqlParser . With either of these, they will break it out a little more granular than you're requesting, which you will then have to piece back together based on parenthesis for example.

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Jan 22, 2016 at 23:45

Bruce Dunwiddie

2,9081 gold badge17 silver badges20 bronze badges

Collectives™ on Stack Overflow

Regex parse sql string

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related