Find SQL function from SQL statement in C# using regex

Question

I want to parse a SQL statement which may use a SQL function inside the query text. Now using C# regex I'd like to parse the string and check if there is any function name(s) used inside the query and extract those. There may be multiple functions used inside the query and each function can have n number of parameters which is not known from before hand.

select * from fnTest(@A, @B) 
select x.* from fnTest(@A, @B) x join fnHelloWord(@C, @D, @E) y on x.SomeID = y.OtherID

In the first sample the regex would return a string value fnTest.
In the second sample the regex would return a list of function name strings like fnTest and fnHelloWord

Federico Piazza · Accepted Answer · 2014-08-12 16:59:26Z

4

If your string are like those you showed, then you can use a regex like this:

\w+(?=\()

Working demo

enter image description here

Btw, if you want to grab the regex content use capturing groups like:

(\w+)(?=\()

Match information:

MATCH 1
1.  [14-20] `fnTest`
MATCH 2
1.  [46-52] `fnTest`
MATCH 3
1.  [68-79] `fnHelloWord`

edited Aug 12, 2014 at 16:59

answered Aug 12, 2014 at 16:53

Federico Piazza

31.2k15 gold badges91 silver badges133 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:29:25Z

2

To add to Fede's answer, You may also need to allow for some number of whitespaces between the function name and the open parenthesis.

e.g. \w+\s*(?=\()

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Aug 12, 2014 at 18:24

Wyatt Earp

1,83314 silver badges23 bronze badges

Comments

Jashaszun · Accepted Answer · 2014-08-12 16:54:26Z

1

Use this regex:

@"([a-zA-Z0-9_]*)\([^\)]*\)"

Basically ([a-zA-Z0-9]*) matches an identifier (a-z, A-Z, or 0-9) and captures it, \( matches a left parenthesis, [^\)]* matches any number of things which are not right parentheses, and then finally \) matches a right parenthesis.

Alternatively, you could use this regex:

@"(\w*)\([^\)]*\)"

Becaue \w matches [a-zA-Z0-9_].

answered Aug 12, 2014 at 16:54

Jashaszun

9,2703 gold badges31 silver badges58 bronze badges

Collectives™ on Stack Overflow

Find SQL function from SQL statement in C# using regex

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related