Re: parsing SQL statement

2008-05-30 Thread Matthew Whipple
On Fri, 2008-05-30 at 19:24 +0700, beast wrote: > Anyone having suggestion parsing SQL statement? > > It should able to parse: > > BLA BALA BALA... > > VALUES( > 'abcd efg',,999, 'some \"STRING\" and \'STR2\' STR3' 'abc

parsing SQL statement

2008-05-30 Thread beast
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