How to extract parameters names from SQL statement using regular expression

Question

I want to extract the parameters names from a query like this:

select * from table where a = :param1 and b = :param2

I wrote this expression:"(?<param>:\w* )"

It gives me :param1 twice

Note: It's in a C#.Net application.

Any Help !!

Thanks

What language is running the Regular Expression: Perl, Java, etc. This can alter the syntax slightly. — Jason McCreary
– Jason McCreary, Commented Jul 4, 2010 at 14:27

marc_s · Accepted Answer · 2010-07-04 14:59:50Z

3

I tried this C# code - it fetches two matches, one for :param1 and another for :param2

Regex getParamRegex = new Regex(@"(?<param>:\w*)", RegexOptions.Compiled | RegexOptions.IgnoreCase);

string input = "select * from table where a = :param1 and b = :param2";

var allMatches = getParamRegex.Matches(input);

foreach (var match in allMatches)
{
   string work = match.ToString();
}

answered Jul 4, 2010 at 14:59

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

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

1 Comment

Homam Over a year ago

Thanks marc_s, I had a problem in C# fetching code, I was fetch matches using Groups collection by group name, now It's ok.

Collectives™ on Stack Overflow

How to extract parameters names from SQL statement using regular expression

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related