Php Regex: how to match repeated patterns

Question

given following text

bond0:       0       0    0    0    0     0          0         0        0       0    0    0    0     0       0          0
eth0: 11329920252 12554462    0    0    0     0          0      3561 13072970332 12899522    0    0    0     0       0          0

I need to capture columns values. I thought something about these lines:

Regex: `(\w+):(?:\s+(\d+))+`
Php: `preg_match_all('/(\w+):(?:\s+(\d+))+/sim', $data, $regs)

But unfortunately it captures only first column.

Array
(
    [0] => Array
        (
            [0] => dummy0:       0       0    0    0    0     0          0         0        0       0    0    0    0     0       0          0
            [1] => bond0:       0       0    0    0    0     0          0         0        0       0    0    0    0     0       0          0
            [2] => eth0: 11329920252 12554462    0    0    0     0          0      3561 13072970332 12899522    0    0    0     0       0          0
            [3] => ip6tnl0:       0       0    0    0    0     0          0         0        0       0    0    0    0     0       0          0
            [4] => lo: 51675995  100695    0    0    0     0          0         0 51675995  100695    0    0    0     0       0          0
            [5] => sit0:       0       0    0    0    0     0          0         0        0       0    0    0    0     0       0          0
            [6] => tunl0:       0       0    0    0    0     0          0         0        0       0    0    0    0     0       0          0
        )

    [1] => Array
        (
            [0] => 0
            [1] => 0
            [2] => 0
            [3] => 0
            [4] => 0
            [5] => 0
            [6] => 0
        )

)

Any suggestion? Thanks `

====EDIT==== Just to be clear: i know that i could preg_match searching for \d+ values or split the whole string in lines and run explode on the each line, but I'm interested in regex solution where I have first column as first member of resulting array(actualy forgot to put capturing braces in the first draft of question), and following columns with data, every line putted in it's dedicated array...

I would prefer not to use explode, for the reasons I've written in question update. Thx anyway. — Alekc
– Alekc, Commented Aug 25, 2013 at 14:56
i'll add my solution in a comment incase you didn't find the preg_match solution: <?php $val = "bond0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 eth0: 11329920252 12554462 0 0 0 0 0 3561 13072970332 12899522 0 0 0 0 0 0"; $arr1 = explode("\n",$val); foreach ($arr1 as $key => $value) { $exp = explode(":",$value); $ex = preg_replace('/\s+/', ' ',trim($exp[1])); $arr[$exp[0]] = explode(" ",$ex); } var_dump($arr); ?> — MaveRick
– MaveRick, Commented Aug 25, 2013 at 15:05
Is the number of columns per row fixed? If not, you are asking for a variable number of captures, and only .NET can do that. — Martin Ender
– Martin Ender, Commented Aug 25, 2013 at 15:05

Jeroen van den Broek · Accepted Answer · 2013-08-25 15:32:52Z

1

Why use preg_match or preg_match_all at all?

$results = array();
foreach (preg_split("/\r\n|\r|\n/", $data) as $line)
{
    list($key, $values) = explode(":", $line);
    $results[$key] = preg_split("/\s/", trim($values));
}

This should work as long as there is no more than one : on every line. Seems to me like it's the shortest and fastest way to write this too.

answered Aug 25, 2013 at 15:32

Jeroen van den Broek

8836 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alekc Over a year ago

Not what I wanted (and it seems that it's not possible to do otherwise), but I'm marking this answer as the most elegant.

Connor Peet · Accepted Answer · 2013-08-25 15:14:14Z

0

Here you go:

$data = explode("\n", $data);
$out = array();
foreach ($data as $d) {
    preg_match_all('/\s(\d+)/', $d, $matches);

Puts $matches[0] equal to an array of matches. You then want to add it to the array of rows:

    $out[] = $matches[0];
}

You now have an jagged array of lines and columns. So, to reference line two column four, you can go to $out[1][3].

edited Aug 25, 2013 at 15:14

answered Aug 25, 2013 at 14:47

Connor Peet

6,2833 gold badges24 silver badges32 bronze badges

8 Comments

Joseph Silber Over a year ago

Why the brackets around the space?

Connor Peet Over a year ago

Ah, not needed. Removed.

bystwn22 Over a year ago

array_map( 'trim', $matches[0] ) is better :)

Connor Peet Over a year ago

It's smaller, but performance takes a hit from it. Foreach is faster and a bit more flexible.

Patrick Evans Over a year ago

/\s(\d+)/, will get the same results without needing to do a trim

|

MaveRick · Accepted Answer · 2013-08-25 15:26:03Z

I know that you are looking for preg_match solution but this is in case you didn't find any usefull answer

<?php
$val = "bond0:       0       0    0    0    0     0          0         0        0       0    0    0    0     0       0          0
eth0: 11329920252 12554462    0    0    0     0          0      3561 13072970332 12899522    0    0    0     0       0          0";
$arr1 = explode("\n",$val);
foreach ($arr1 as $value) {
    $exp = explode(":",$value);
    $ex = preg_replace('/\s+/', ' ',trim($exp[1]));
    $arr[$exp[0]] = explode(" ",$ex);
}
var_dump($arr);
?>

results:

array (size=2)
  'bond0' => 
    array (size=17)
      0 => string '' (length=0)
      1 => string '0' (length=1)
      2 => string '0' (length=1)
      3 => string '0' (length=1)
      4 => string '0' (length=1)
      5 => string '0' (length=1)
      6 => string '0' (length=1)
      7 => string '0' (length=1)
      8 => string '0' (length=1)
      9 => string '0' (length=1)
      10 => string '0' (length=1)
      11 => string '0' (length=1)
      12 => string '0' (length=1)
      13 => string '0' (length=1)
      14 => string '0' (length=1)
      15 => string '0' (length=1)
      16 => string '0' (length=1)
  'eth0' => 
    array (size=17)
      0 => string '' (length=0)
      1 => string '11329920252' (length=11)
      2 => string '12554462' (length=8)
      3 => string '0' (length=1)
      4 => string '0' (length=1)
      5 => string '0' (length=1)
      6 => string '0' (length=1)
      7 => string '0' (length=1)
      8 => string '3561' (length=4)
      9 => string '13072970332' (length=11)
      10 => string '12899522' (length=8)
      11 => string '0' (length=1)
      12 => string '0' (length=1)
      13 => string '0' (length=1)
      14 => string '0' (length=1)
      15 => string '0' (length=1)
      16 => string '0' (length=1)

Casimir et Hippolyte · Accepted Answer · 2021-11-13 22:44:40Z

0

You can do it like this:

$subject = <<<LOD
dummy0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
bond0:  0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
eth0: 11329920252 12554462 0 0 0 0 0 3561 13072970332 12899522 0 0 0 0 0 0
ip6tnl0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
lo: 51675995 100695 0 0 0 0 0 0 51675995 100695 0 0 0 0 0 0
sit0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
tunl0: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LOD;

$pattern = '~^(?<item>\w+):|\G\h+(?<value>\d+)~m';
preg_match_all($pattern, $subject, $matches, PREG_SET_ORDER);
$i=-1;
foreach($matches as $match) {
    if (isset($match['value']))
        $result[$i]['values'][] = $match['value'];
    else {
        $i++;
        $result[$i]['item'] = $match['item']; }
}
print_r($result);

You will obtain the format you describe in your EDIT.

Pattern details:

~               # pattern delimiter
^               # anchor for the line start (in multiline mode)
(?<item>\w+)    # named capture "item"
:       
|               # OR
\G              # force the match to be contigous from precedent
\h+             #
(?<value>\d+)   # named capture "value"
~m              # pattern delimiter, m modifier for multiline mode

edited Nov 13, 2021 at 22:44

answered Aug 25, 2013 at 15:12

Casimir et Hippolyte

90k5 gold badges102 silver badges131 bronze badges

2 Comments

Connor Peet Over a year ago

That's an incredibly bulky way to do it.

Casimir et Hippolyte Over a year ago

@ConnorPeet: Not so "bulky" as you think, since the pattern is apply only once.

Collectives™ on Stack Overflow

Php Regex: how to match repeated patterns

4 Answers 4

1 Comment

8 Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

8 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related