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',,,, 'abcd, def, fghi' > ) > > I'm using tr and then split by "," but it will fall when seeing comma > inside the single quote. >
I'm actually about to look into a SQL parsing solution myself. There appear to be several modules on CPAN which should be at least a good place to start. > Thanks. > > --budhi > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
