PHP- Turning a String to Array with RegEx statement

Question

I'm getting this string which I can't control:

$string = '[{"val":"agent,,james,,89","number":0,"dID":0}, {"val":"house,,Villa,,389m","number":1,"dID":2}]';

Would like to only collect the val and put them into an array where they are separated by the two commas

End results:

var_dump($resArr) // Array [{"agent", "james", "89"}, {"house", "villa", "389m"}]

What I've done so far:

$string = '[{"val":"agent,,james,,89","number":0,"dID":0}, {"val":"house,,Villa,,389m","number":1,"dID":2}]';

parse_str(stripslashes(str_replace(["'=>'","','"],['=','&'],trim($string,"'"))),$form_data);

var_dump($form_data);

Liftoff · Accepted Answer · 2021-06-19 22:36:53Z

1

Since your initial string is JSON, you can easily parse it with json_decode(). Then just iterate through the array and explode() the "val" by the delimiter ,, and add it to an array.

<?php

$string = '[{"val":"agent,,james,,89","number":0,"dID":0}, {"val":"house,,Villa,,389m","number":1,"dID":2}]';

$json = json_decode($string, true);
$output = [];
foreach($json as $elm)
{
    $val = $elm["val"];
    $words = explode(",,", $val);
    $output[] = $words;
}

var_dump($output);
?>

This gives $output a value of

[["agent", "james", "89"], ["house", "villa", "389m"]]

Demo here

answered Jun 19, 2021 at 22:36

Liftoff

25.6k16 gold badges74 silver badges127 bronze badges

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

Comments

AbraCadaver · Accepted Answer · 2021-06-24 21:47:31Z

0

You have an accepted answer, but I was bored:

$result = array_map(function($v) {
                        return explode(',,', $v['val']);
                    }, json_decode($string, true));

edited Jun 24, 2021 at 21:47

answered Jun 19, 2021 at 23:25

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

Collectives™ on Stack Overflow

PHP- Turning a String to Array with RegEx statement

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related