Here's a (somewhat ugly) attempt using Text::Balanced. The
idea is to extract the balanced parentheses fragments, in order to apply
the split to the remaining parts of the string only.
use strict;
use warnings;
use Text::Balanced qw(extract_bracketed);
sub mysplit {
my $text = shift;
my @fields;
do {
my ($paren, $post, $pre) = extract_bracketed($text, '()', '[^(
+]*');
my $s = '';
if ($pre) {
$s = $pre;
} elsif (!$paren) {
$s = $post;
$post = '';
}
$s =~ s/^,//; # get rid of superfluous leading comm
+a
my @f = split /,/, $s;
$f[-1] .= $paren if @f; # append balanced parens part to last
+ elem
push @fields, @f;
$text = $post;
} while ($text);
return @fields;
}
my $sql = "f1,f2, SUM(f3),CONCAT(f4,f5, f6), f7";
print "$_\n" for mysplit($sql);
Output:
f1
f2
SUM(f3)
CONCAT(f4,f5, f6)
f7
(Not well tested — also, I have that feeling there must be something more elegant than this
mess of conditionals... but it's escaping me right now :)
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.