Re^2: Skip quoted string in regex

[LanX]

Some background...

> In the qq(failure_reason <> 'Response=X') example given, you only actually want to split once.)

I had the same idea but 3 seemed right, since 3 fields are returned.

It's a bit confusing, b/c according to the docs "LIMIT... represents the maximum number of fields the EXPR will be split into".

But the middle field originates from the (regex-group) within the $opr_regex.

But still, split is the wrong approach here, b/c the LHS could be quoted too.

[AnomalousMonk]

... the LHS could be quoted too.

I missed that bit in your reply. I was thinking of responding with a semi-elaborate regex approach, but if there's an SQL parser available on CPAN, I agree that's the way to go: wheel, reinvention, and all that.