I am trying to get the word after Sysdba.
out of a string. Here is a example where my result would be PRODUCTION
CAST(CASE WHEN SYSDBA.PRODUCTION.SHIPPING_COMPLETE_DATE IS NOT NULL THEN 1 ELSE 0 END AS bit) AS [Shiping Completed]]
I created the regex expression
Regex CatagoryRegex = new Regex(@"SYSDBA\.(.#)\.", RegexOptions.IgnoreCase | RegexOptions.Compiled);
however when I call var tmp = CatagoryRegex.Match(SelectText);
I get no matches. I know I am most likely making a simple mistake but I can not spot it.