Hello,

I want to process an SQL string. It should leave only the SELECT-part, the rest
should be cut.

SELECT bla, bli from hallo WHERE x=4

I define three groups with \(\) and substitute it only by the first group.

In my editor vim the subsitution works as follows:

:s/^\(.*\)\([ ^I]\+from[ ^I]\+\)\(.*\)$/\1

results in

SELECT bla, bli

Question:
Beside of the reg-ex-dialect ( i.e. .Net uses () instead of \(\) ), how do I
work with Groups in .Net?

Thank You

Joachim