Regex to select column names from SQL query

Question

I have a regexp that selects the columns from SQL query: \bwf\.[^,|^\s|^)]*

So from both queries

SELECT (wf.Name,
       wf.Status)

SELECT wf.Name, wf.Status

it will return "wf.Name", "wf.Status". But also I want to cover case when column contains round brackets:

SELECT (wf.Name,
       wf.Status())

regexp should return "wf.Name", "wf.Status()".

I tried to do it through non-capturing group (?:(?!\s|,|<statement>).)* but without success.

Wiktor Stribiżew · Accepted Answer · 2021-04-22 09:14:36Z

1

You can use

\bwf(?:\.\w+)+(?:\(\))?

See the regex demo. Details:

\b - a word boundary
wf - a wf string
(?:\.\w+)+ - one or more repetitions of a . and one or more word chars (?:\(\))? - an optional occurrence of a () substring.

answered Apr 22, 2021 at 9:14

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

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

1 Answer 1