Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
PerlMonks  

Re: Pull info from select clause.

by PodMaster (Abbot)
on May 11, 2004 at 20:48 UTC ( [id://352589]=note: print w/replies, xml ) Need Help??


in reply to Pull info from select clause.

So, I guess what I want to do is split on the commas, as long as they are not contained inside a set of parenthesis. I am lost on how to accomplish this with a regex.
This is easily accomplished with a regex (and the m// operator), but not so easy with split. What you want to do is parse SQL, and the best way to do that is not to do it :) meaning use the CPAN or SQL::Statement.

update: stricken extraneous bs. split or m// its all the same, you still have to parse the SQL.

MJD says "you can't just make shit up and expect the computer to know what you mean, retardo!"
I run a Win32 PPM repository for perl 5.6.x and 5.8.x -- I take requests (README).
** The third rule of perl club is a statement of fact: pod is sexy.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://352589]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others rifling through the Monastery: (5)
As of 2024-04-24 22:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found