parsing SQL statement

[email protected] (beast)
Newsgroups perl.beginners
Message-ID <[email protected]> 
Anyone having suggestion parsing SQL statement?

It should able to parse:

BLA BALA BALA...

VALUES(
  'abcd efg',,999, 'some \"STRING\" and \'STR2\' STR3',,,, 'abcd, def, fghi'
)

I'm using tr and then split by "," but it will fall when seeing comma
inside the single quote.

Thanks.

--budhi
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.