php array select a Key Value in multiple arrays and change them

Question

is there a simple solution I can put inside a function to resolve the following:

I have multiple arrays as follows:

Array
(
[0] => A
[1] => 100_1
[2] => 1
[3] => 1184
[4] => 0
)

Array
(
[0] => A
[1] => 100_2
[2] => 2
[3] => 1185
[4] => 0
)

Array
(
[0] => A
[1] => 100_3
[2] => 3
[3] => 1186
[4] => 0
)

Array
(
[0] => A
[1] => 101_2
[2] => 2
[3] => 1188
[4] => 0
)

Array
(
[0] => A
[1] => 302
[2] => 0
[3] => 1161
[4] => 0
)

What I'd like to do is to select all the values which have _1,2,3 only, and remove the _1,2,3 so the desired result would be:

Array
(
[0] => A
[1] => 100
[2] => 1
[3] => 1184
[4] => 0
)

Array
(
[0] => A
[1] => 100
[2] => 2
[3] => 1185
[4] => 0
)

Array
(
[0] => A
[1] => 100
[2] => 3
[3] => 1186
[4] => 0
)

Array
(
[0] => A
[1] => 101
[2] => 2
[3] => 1188
[4] => 0
)

Array
(
[0] => A
[1] => 302
[2] => 0
[3] => 1161
[4] => 0
)

Notice only values which contain _1,2,3 have been changed. Many thanks for your help it's much appreciated.

The code I have so far is:

foreach($data as $line) {
    if(substr($line,0,1)=="A") {
    if(!$first) {
        $parts = explode(chr(9), $line);            
        list($num1, $num2) = explode('_', $parts[1]); //this code needs to come first
        $parts[2] = isset($num2) ? $num2 : $parts[2]; //it replaces key[2] with _* (1,2,3)

//echo "<pre>"; print_r($parts); echo "</pre>";

   //the code to remove _* needs to go here.

    $pos = strpos($parts[1], '_');  // this was all it needed a simple two liner
    if($pos !== false) $parts[1] = substr($parts[1], 0, $pos);

I have been all day - I made edits. I would say that 'Machavity' is the closest which I will test shortly. — Renny
– Renny, Commented Aug 6, 2014 at 13:14

Kumar Saurabh Sinha · Accepted Answer · 2014-08-06 12:08:49Z

1

you can use the following:

function formatArray($array)
{
    if(is_array($array))
    {
        foreach($array as $key=>$value)
        {
            $array[$key] = str_replace('_1', '', $value);
            $array[$key] = str_replace('_2', '', $value);
            $array[$key] = str_replace('_3', '', $value);
        }
        return $array;
    }
    return false;

}

Call this function with every array as parameter or you can assign the complete array to and parent array and then add one more foreach to loop through it.

answered Aug 6, 2014 at 12:08

Kumar Saurabh Sinha

8708 silver badges23 bronze badges

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

Comments

kevdev · Accepted Answer · 2014-08-06 12:09:21Z

1

Just write a function which uses preg_replace to alter your data:

<?php
$test_data = array("A", "100_1", "0", "1184", "0");

function removeValuesWithUnderScore(array $arr){
    //Loop over array
    foreach($arr as $key => $value){
        $arr[$key] = preg_replace('/_[1-3]/', '', $value);
    }

    //Return altered array
    return $arr;
}

$test_data = removeValuesWithUnderScore($test_data);

answered Aug 6, 2014 at 12:09

kevdev

1,1248 silver badges9 bronze badges

Comments

Prasanth Bendra · Accepted Answer · 2014-08-06 12:49:51Z

1

Try this :

$array = array("A", "100_1", 0, 1184, 0);
$array = array_map(
    function($str) {
        return preg_replace('/\_[\d]+/', '', $str);
    },
    $array
);

print_r($array)

Edit : If OP needs only _1, _2 and _3 to be removed :

$array = array("A", "100_3", 0, 1184, 0);
$array = array_map(
    function($str) {
        return preg_replace('/\_[1|2|3]/', '', $str);
    },
    $array
);

print_r($array)

edited Aug 6, 2014 at 12:49

answered Aug 6, 2014 at 12:11

Prasanth Bendra

33.1k9 gold badges56 silver badges74 bronze badges

7 Comments

kevdev Over a year ago

Would not work as he said, only _1, _2 and _3 should be removed.

Prasanth Bendra Over a year ago

@kevdev : Can you explain that?

Prasanth Bendra Over a year ago

@kevdev : Ok I got it :)

kevdev Over a year ago

"What I'd like to do is to select all the values which have _1,2,3 only, and remove the _1,2,3" the op tells us in his question he want to remove _1,2,3 (_1,_2,_3) only, if this is not a mistake (Could also be, but the text says otherwise) your code will also remove for example _4, _5, _6 and so on.

Prasanth Bendra Over a year ago

@kevdev : Ohh sorry got confused :)

|

Machavity · Accepted Answer · 2014-08-06 14:23:36Z

0

Assuming the _1 etc. always happens in array[1]

foreach($array as $row) {
    $pos = strpos($row[1], '_');
    if($pos !== false) $row[1] = substr($row[1], 0, $pos);
}

edited Aug 6, 2014 at 14:23

answered Aug 6, 2014 at 12:09

Machavity♦

31.8k27 gold badges97 silver badges108 bronze badges

3 Comments

Renny Over a year ago

Hello Machavity this is so dam close : $pos = strpos($parts[1], '_'); if($pos !== false) $parts[1] = substr($parts[1], 0, $pos - 1); But it removes a '0' so key [1] shows 10 but should show 100 etc

Renny Over a year ago

Its ok the last $pos - 1; needs to be $pos -0; now it works great :)

Renny Over a year ago

Machavity can you go to my profile and there's 1 unanswered question I think you can help?

Steve · Accepted Answer · 2014-08-06 12:16:05Z

0

presuming you want any value with _xxx appended to be replaced:

foreach($array as &$element){
    $element = strstr($element, '_', true)?:$element;
}

answered Aug 6, 2014 at 12:16

Steve

20.5k5 gold badges47 silver badges71 bronze badges

Collectives™ on Stack Overflow

php array select a Key Value in multiple arrays and change them

5 Answers 5

Comments

Comments

7 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

7 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related