|Do you know where your variables are?|
need to parse firts part of SQL-query (regex question)by jeanluca (Deacon)
|on Jan 17, 2008 at 14:10 UTC||Need Help??|
jeanluca has asked for the wisdom of the Perl Monks concerning the following question:
What started as a simple exercise, has now gone beyond my (regex) knowledge.
I need to split the following on ',':
The problem is that I don't want to split the stuff inside the CONCAT.
Firts I thought that it was easy, like
This raised the following error
Is there a regex that can do this, or should I do it just differently ?
Update: from the answers I get the impression that a SQL-parser-module would be the best solution, but for now I choose the quick solution provided by martin.
Thnx for all the suggestion!!