split by comma inside braces except another braces inside braces

Question

I want to split by comma inside braces except another braces inside braces

$q1 ="CREATE TABLE notes(id INTEGER,code DECIMAL (4,2),PRIMARY KEY (id))";
$q2 ="CREATE TABLE notes(id INTEGER,code TEXT)";

$r = preg_split('/\([^()]*\)(*SKIP)(*F)|[()]|,/', $q1);//$q1 splitted but $q2 no
print_r($r);

The final result should be:

for $q1 :

   array(
         0 => id INTEGER
         1 => code DECIMAL (4,2)
         2 => PRIMARY KEY (id)
   );

for $q2 :

   array(
        0 => id INTEGER
        1 => code TEXT
   );

No one will be able to answer your question. It's too vague. — Teddy Codes, Jan 17 '17 at 12:22
Your question is not clear... AFAIK, you need to split this string by comma, but the `code DECIMAL (4,2)` stay intact? — Pipe, Jan 17 '17 at 12:29
This question may be related... http://stackoverflow.com/questions/15233953/php-split-string-on-comma-but-not-when-between-braces-or-quotes — Pipe, Jan 17 '17 at 12:38

score 1 · Accepted Answer · answered Mar 28 '17 at 17:03

Code: (PHP Demo)

$sqls = array(
    "CREATE TABLE notes(id INTEGER,code DECIMAL (4,2),PRIMARY KEY (id))",
    "CREATE TABLE notes(id INTEGER,code TEXT)"
);

foreach($sqls as $sql){
    if(preg_match_all("/(?:^.+?\(|,)(?:\K[\w ]+(?:\([\S].*?\))?)/", $sql,$matches)){
        echo "<pre>";
            var_export($matches[0]);
        echo "</pre>";
    }
}

Output:

// first $matches...
array(
    0 => 'id INTEGER',
    1 => 'code DECIMAL (4,2)',
    2 => 'PRIMARY KEY (id)'
)
// second $matches...
array(
    0 => 'id INTEGER',
    1 => 'code TEXT'
)

Regex Breakdown: (Regex Demo)

(?:^.+?\(|,)          #group everything from the start to 1st parenthesis or a comma
(?:\K[\w ]+           #\K means "only retain text from this point", group words and spaces
    (?:\([\S].*?\))?  #optionally group parenthetical text
)

Using \K permits the exclusion of a capture group and preg_match_all returns the desired string (full string) in the first subarray. The benefit is a $matches array that half the size of an array with a capture group.

@edd If my answer satisfies, please award it the green tick. Otherwise please leave me a comment that explains what remains to be fixed. — mickmackusa, Mar 28 '17 at 17:05

score 0 · Answer 2 · answered Jan 17 '17 at 13:35

0

If embeded parenthesis contain only digits, this does the job:

$sqls = array(
"CREATE TABLE notes(id INTEGER,code DECIMAL (4,2),PRIMARY KEY (id))",
"CREATE TABLE notes(id INTEGER,code TEXT)"
);

foreach ($sqls as $sql) {
    $arr = preg_split("/(?<!\d)[(),](?!\d)/", $sql);
    print_r($arr);
}

Output:

Array
(
    [0] => CREATE TABLE notes
    [1] => id INTEGER
    [2] => code DECIMAL (4,2)
    [3] => PRIMARY KEY 
    [4] => id
    [5] => 
    [6] => 
)
Array
(
    [0] => CREATE TABLE notes
    [1] => id INTEGER
    [2] => code TEXT
    [3] => 
)

answered Jan 17 '17 at 13:35

Toto

89,455
62
89
125

1

You are closer with this ideea – edd Jan 17 '17 at 13:49
It is a partial answer, but I try to adapt this idea (if you have a better idea ... I wait) – edd Jan 18 '17 at 12:03

split by comma inside braces except another braces inside braces

2 Answers2