Hi,
I was hoping to use the pattern matching drop-in to pull apart some SQL. Let's say I'm expecing a SQL like
SELECT [distinct] <MyField>[, second field][, third field] FROM <tablename>
where the elements in brackets may or may not be there, I'm a bit lost. It's possible to do a match like [a-Z]* to get zero or more blocks of alpha characters but not a specific word.
Is this solveable using the Oscript pattern match?
-Hugh
