str_replace specific value in multidimensional array

Question

I would like to replace the , with . in some Keys like [Price] for instance.

Given this array:

Array
(
    [0] => Array
        (
            [Product line] => Misc
            [Seller] => aaa.com
            [Tracking ID] => bbbb
            [Date shipped] => October 23, 2015
            [Price] => 60,43
            [Referral fee rate] => 3,00%                
            [Quantity] => 2
            [Revenue] => 120,86
            [Earnings] => 3,62
            [Sub Tag] => xxxx
        )

    [1] => Array
        (
            [Product line] => Misc
            [Seller] => aaaa.com
            [Tracking ID] => bbbb
            [Date shipped] => October 23, 2015
            [Price] => 9,34
            [Referral fee rate] => 6,96%                
            [Quantity] => 1
            [Revenue] => 9,34
            [Earnings] => 0,65
            [Sub Tag] => xxxx
        )
)

And the following function:

function str_replace_specific_value($sSearch, $sReplace, &$aSubject){
    foreach($aSubject as $sKey => $uknValue) {
        if(is_array($uknValue)) {
            foreach($sKey as $fKey => $fuknValue) {
                $uknValue['Price'] = str_replace($sSearch, $sReplace, $fuknValue);
            }
        }
    }   
}

Can someone help me please? I tried a couple of things but can't get it to work.

Thanks, can you take a look at the function I just posted? I'm close, but something's still not right — cliff
– cliff, Commented Nov 3, 2015 at 11:03
Instead of all that loops, why not use array_walk_recursive()? (check the comments to see how to change the array in the callback function) — kero
– kero, Commented Nov 3, 2015 at 11:04
As a side-note, you should really return the modified array from your function instead of sending the original by reference; your current method makes testing and troubleshooting very hard. — jeroen
– jeroen, Commented Nov 3, 2015 at 11:15
@Uchiha I tried this but it doesn't work, the output is still comma not dot. — cliff
– cliff, Commented Nov 3, 2015 at 11:17

Devendra Singh Bhandari · Accepted Answer · 2015-11-03 11:11:53Z

3

You can iterate through each element of associative array using array_walk_recursive function.

Here $result is your input array.

array_walk_recursive($result, 'replacer');

/**
 * Replace comma with dot from 'Price' element of associative array.
 * This function call recursively
 *
 * @access public
 *
 * @param string|int|null $item
 * @param string $key
 * @return void
 */
public function replacer(& $item, $key)
{
    if ($key == 'Price') {
        $item = str_replace(",", ".", $item);
    }
}

var_dump($result) to check the output after replacing , with .

answered Nov 3, 2015 at 11:11

Devendra Singh Bhandari

5744 silver badges14 bronze badges

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

Comments

javier_domenech · Accepted Answer · 2015-11-03 11:19:36Z

Change the main array, like this:

function str_replace_specific_value($sSearch, $sReplace, &$aSubject){
    foreach($aSubject as $key => $sub_array) {
        if(is_array($sub_array)) {
            foreach($sub_array as $sub_key => $sub_value) {
                $sSubject[$key][$sub_key] = str_replace($sSearch, $sReplace, $sub_value);
            }
        }
    }   
}

In casu you wanted to do only on a set of keys, you would need to declare those keys and use this other function:

$keys_to_be_replaced = ['price','whatever'];

function str_replace_specific_value($sSearch, $sReplace, &$aSubject, $keys_to_be_replaced){
    foreach($aSubject as $key => $sub_array) {
        if(is_array($sub_array)) {
            foreach($sub_array as $sub_key => $sub_value) {
                if(in_array($sub_key,$keys_to_be_replaced))
                  $sSubject[$key][$sub_key] = str_replace($sSearch, $sReplace, $sub_value);
            }
        }
    }   
}

Criesto · Accepted Answer · 2015-11-03 11:12:52Z

0

You can try this:

$arr[0] = array("price" => "60,53");
$arr[1] = array("price" => "9,34");

foreach ($arr AS $key => $value) {
   $arr[$key]["price"] = str_replace(",", ".", $arr[$key]["price"]);
}
echo "<pre>";
print_r($arr);

Output:

Array
(
    [0] => Array
        (
            [price] => 60.53
        )

    [1] => Array
        (
            [price] => 9.34
        )

)

answered Nov 3, 2015 at 11:12

Criesto

2,0014 gold badges33 silver badges41 bronze badges

Comments

iknow · Accepted Answer · 2020-09-20 09:46:09Z

0

Alternate

array_walk_recursive($r, function (your args){
});

edited Sep 20, 2020 at 9:46

iknow

10.3k15 gold badges47 silver badges81 bronze badges

answered Sep 19, 2020 at 19:17

Saaram

3373 gold badges8 silver badges29 bronze badges

1 Comment

Mark Rotteveel Over a year ago

Please don't post only code as answer, but also provide an explanation what your code does and how it solves the problem of the question. Answers with an explanation are usually more helpful and of better quality, and are more likely to attract upvotes.

RafaSashi · Accepted Answer · 2022-05-12 15:09:04Z

0

Via array_walk_recursive if you want to change the values of an existing multi-dimensional array you need to specify the first argument of the callback as a reference by preceding the variable with an ampersand (&)

array_walk_recursive($data, function(&$item, $key){
            
    if( $key == 'Price' ){
                
        $item = str_replace(',','.',$item);
    }
});

answered May 12, 2022 at 15:09

RafaSashi

17.3k8 gold badges89 silver badges99 bronze badges

Collectives™ on Stack Overflow

str_replace specific value in multidimensional array

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related