Convert number sequence to array in PHP

Question

Kinda of a noobie in PHP and Regex, I receive the following from a web service:

test:002005@1111@333333@;10205@2000@666666@;002005@1111@55555@;

The above line is a sequence of 3 numbers which repeats 3 times. I would like to get the 3rd number of each sequence and I believe the best course (besides 3000 explodes) would be preg_match_all but I am having a tough time wrapping my mind around RegEx.

The end result should look like this:

 Array
    (
        [0] => 333333
        [1] => 666666
        [2] => 55555
    )

Thanks in advance for any help.

codaddict · Accepted Answer · 2012-05-10 11:22:18Z

5

if(preg_match_all('/.*?(?:\d+@){2}(\d+)@;/',$s,$m)) {
        print_r($m[1]);
}

http://ideone.com/99M9t

or

You can do it using explode as:

$input = rtrim($input,';');
$temp1 = explode(';',$input);
foreach($temp1 as $val1) {
        $temp2 = explode('@',$val1);
        $result[] = $temp2[2];
}
print_r($result);

http://ideone.com/VH29g

edited May 10, 2012 at 11:22

answered May 10, 2012 at 11:16

codaddict

457k83 gold badges501 silver badges537 bronze badges

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

1 Comment

Xander Over a year ago

Thanks a lot, that did the trick. I like this one due to defining the fact that there 2 "@XXXX" before the one that's needed. Great job!

Ron van der Heijden · Accepted Answer · 2012-05-10 11:17:04Z

2

Use the function explode()

<?php

$pizza  = "piece1@piece2@piece3@piece4@piece5@piece6";
$pieces = explode("@", $pizza);
echo $pieces[0]; // piece1
echo $pieces[1]; // piece2

?>

answered May 10, 2012 at 11:17

Ron van der Heijden

15.1k7 gold badges62 silver badges86 bronze badges

3 Comments

TaZ Over a year ago

He asked for a version without explode, I assume his input is very large and he wants a fast/scalable solution. (I can't say anything on running times of either approach right now.)

Kris Over a year ago

@Taz: He asked for a version without 3000 explodes, I see only 1. this satisfies that requirement nicely I believe. Though this doesn't actually get the output he asked for...

TaZ Over a year ago

I believe he needs another explode to get the third item in every $piece. That explode would be in a loop so you get n+1 explode calls.

Kris · Accepted Answer · 2012-05-10 11:21:47Z

0

I don't remember exactly how the saying goes but...

"You have a problem and decide to use regular expressions... now you have two problems."

Your problem can easily be solved if we assume 'test:' isn't part of the actual string to be parsed.

<?php

$in = '002005@1111@333333@;10205@2000@666666@;002005@1111@55555@;';

function splitGroupsAndGetColumn($input, $groupSeparator, $columnSeparator, $columnIndex, $skipEmpty=true)
{
    $result = array();

    $groups = explode($groupSeparator, $input);
    foreach($groups as $group)
    {
        $columns = explode($columnSeparator, $group);
        if (isset($columns[$columnIndex]))
        {
            array_push($result, $columns[$columnIndex]);
        }
        else if (! $skipEmpty)
        {
            array_push($result, NULL);
        }
    }

    return $result;
}

var_dump(splitGroupsAndGetColumn($in, ';', '@', 2));

Output:

array(3) {
  [0]=>
  string(6) "333333"
  [1]=>
  string(6) "666666"
  [2]=>
  string(5) "55555"
}

answered May 10, 2012 at 11:21

Kris

42.1k9 gold badges78 silver badges103 bronze badges

7 Comments

aurora Over a year ago

The saying must have come from somebody without knowledge of regular expressions ;-) ... at least: i wonder what makes someone think that loops are any better than regular expressions for such a simple task?

Kris Over a year ago

I dunno, but I like regexes almost as much as the original saying. regexes are fine IMHO but not to be used like the proverbial hammer.

aurora Over a year ago

I've seen a regexp in some book for validating e-mail addresses which spanned several pages. I think that would be a case where i would agree with you :-)

Kris Over a year ago

@harald: exactly. /([b]{2}|[^b]{2})/

Kris Over a year ago

@YagoRiveiro: indeed. also infinitely more readable if you ask me though.

|

aurora · Accepted Answer · 2012-05-10 11:28:16Z

0

You could use preg_match_all for this task, which makes the task quite simple:

$a = "test:002005@1111@333333@;10205@2000@666666@;002005@1111@55555@;";

preg_match_all('/@(\d+)@;/', $a, $m);

print_r($m);

$m[1] contains the output, you want.

Reference: http://php.net/manual/en/function.preg-match-all.php

edited May 10, 2012 at 11:28

answered May 10, 2012 at 11:16

aurora

9,6378 gold badges39 silver badges54 bronze badges

Comments

Yago Riveiro · Accepted Answer · 2012-05-10 14:46:01Z

My version :)

The regex (\d+) means I want all that is a number one or more

php > $a = '002005@1111@333333@;10205@2000@666666@;002005@1111@55555@';
php > preg_match_all('/(\d+)/',$a,$matches);
php > var_dump($matches);
array(2) {
  [0]=>
  array(9) {
    [0]=>
    string(6) "002005"
    [1]=>
    string(4) "1111"
    [2]=>
    string(6) "333333"
    [3]=>
    string(5) "10205"
    [4]=>
    string(4) "2000"
    [5]=>
    string(6) "666666"
    [6]=>
    string(6) "002005"
    [7]=>
    string(4) "1111"
    [8]=>
    string(5) "55555"
  }
  [1]=>
  array(9) {
    [0]=>
    string(6) "002005"
    [1]=>
    string(4) "1111"
    [2]=>
    string(6) "333333"
    [3]=>
    string(5) "10205"
    [4]=>
    string(4) "2000"
    [5]=>
    string(6) "666666"
    [6]=>
    string(6) "002005"
    [7]=>
    string(4) "1111"
    [8]=>
    string(5) "55555"
  }
}

Collectives™ on Stack Overflow

Convert number sequence to array in PHP

5 Answers 5

1 Comment

3 Comments

7 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

3 Comments

7 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related