preg_match picking values from a table

[kaf3773]

Hi

 

I have a php script that executes a command to get the following results below

I will appreciate it very much if you can help me with a php preg_match that can

pick the percentage in the second column based on the supplied queue number in the first column

Thanks in advance.

==================================================================

 

QUEUE USAGE TOTAL book1 book2

 

------------------------------------------------------------------

 

0001 18% 822 481 98

 

0002 16% 345 765 88

 

0003 10% 400 300 166

 

0004 15% 994 322 177

 

0005 17% 348 297 131

 

----------------------------------------------------------

[requinix]

Try feeding

/^(\d+)\s+(\d+)%/m

to preg_match_all().

[kaf3773]

i tried it like you said where $content is a variable that holds the results of the table.

 

 

preg_match_all('/^(\d+)\s+(\d+)%/m', $content, $match, PREG_PATTERN_ORDER);

print_r($match[0]);

 

 

This is what is printed out after runing the code. Help will really be appreciated

 

Array

(

)

[requinix]

<?php

$content = <<<TEXT
QUEUE   USAGE     TOTAL  book1   book2

------------------------------------------------------------------

0001    18%       822   481    98

0002    16%       345   765    88

0003    10%       400   300   166

0004    15%       994   322        177

0005    17%       348   297        131

----------------------------------------------------------
TEXT;

preg_match_all('/^(\d+)\s+(\d+)%/m', $content, $match, PREG_PATTERN_ORDER);
print_r($match);

Array
(
    [0] => Array
        (
            [0] => 0001 18%
            [1] => 0002 16%
            [2] => 0003 10%
            [3] => 0004 15%
            [4] => 0005 17%
        )

    [1] => Array
        (
            [0] => 0001
            [1] => 0002
            [2] => 0003
            [3] => 0004
            [4] => 0005
        )

    [2] => Array
        (
            [0] => 18
            [1] => 16
            [2] => 10
            [3] => 15
            [4] => 17
        )

)

[kaf3773]

Thank you so much requinix

I really appreciate this.

How can i print out the items in the Array on their own.

For instance how can i get just

18

16

10

15

17

 

[2] => Array

(

[0] => 18

[1] => 16

[2] => 10

[3] => 15

[4] => 17

)

 

 

Thanks

[requinix]

Well, it's right there in the main array so

$match[2]

[kaf3773]

Thanks so much this worked out great