Spliting an array value and concatinating the array value in php

Question

I have an array of strings of the format "Year-Month_ID". I'd like to split each item in two at the '_'. Then, for the items that have the same prefix (year & month), join the IDs with '_' after the prefix ("Year-Month_ID_ID..."). For example, if I have the data:

array(
    '2010-December_9',
    '2010-December_19',
    '2011-June_4',
    '2011-September_38',
    '2011-November_29',
    '2011-November_9'
)

I want the result to be:

array(
    '2010-December_9_19',
    '2011-June_4',
    '2011-September_38',
    '2011-November_29_9'
)

How can I do this?

Samples should be complete & concise code. The output of print_r isn't particularly useful. var_export will give a PHP-parseable representation of built-in data types. — outis
– outis, Commented Dec 3, 2011 at 5:57
hi outis, please look at my array values, that is string format ,not date format. The last string is not date, its ID. There u can see last digits are >= 31 day(eg:"2011-September_38"). Please always read questions fully, before taking decision. :) — Balaji Kandasamy
– Balaji Kandasamy, Commented Dec 3, 2011 at 6:44

ajreal · Accepted Answer · 2011-12-03 05:21:34Z

2

$arr = array();
foreach ($dates as $val)
{   
    $tmp = explode("_", $val);
    if ( ! isset($arr[$tmp[0]]))
    {   
        $arr[$tmp[0]] = array();
    }   
    $arr[$tmp[0]][] = $tmp[1];
}   
$final = array();
foreach ($arr as $key=>$val)
{   
    $final[] = $key."_".implode("_", $val);
}

answered Dec 3, 2011 at 5:21

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

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

1 Comment

ajreal Over a year ago

sama sama (You are an india can speak Malayu?)

Abhay · Accepted Answer · 2011-12-03 06:19:39Z

1

This might help:

$arr = Array('2010-December_9', '2010-December_19', '2011-June_4', '2011-September_38', '2011-November_29', '2011-November_9'); // input array
$arrTemp = $arrOutput = Array();
foreach ($arr as $val) {
    if (preg_match('/([0-9]{4})-([a-z]+)_([0-9]{1,2})/i', $val, $arrMatches)) {
        $arrTemp[$arrMatches[1] . '-' . $arrMatches[2]][] = $arrMatches[3];
    }
}
foreach ($arrTemp as $key => $day) {
    $arrOutput[] = $key . '_' . implode('_', $day);
}
print_r($arrOutput);

answered Dec 3, 2011 at 6:19

Abhay

6,6852 gold badges26 silver badges17 bronze badges

Comments

Gaurav Shah · Accepted Answer · 2011-12-03 05:22:26Z

0

explode('_',$str)

http://php.net/manual/en/function.explode.php

I will put down a simple logic .. implement it with code.

create array2

for loop till all elem in array1
  loop2 for array1
    if index1!=index2 && explode('_',array[index1])[0]== explode('_',array[index2])[0]
         array2.push( explode('_',array[index1])[0]).explode('_',array[index1])[1]).'_'.explode('_',array[index2])[1])
          array1.pop(index1)
          array1.pop(index2)
  loop end
loop end

for loop till all rem elem in array1
  array2.push(array1[index])
 loop end

edited Dec 3, 2011 at 5:22

answered Dec 3, 2011 at 5:08

Gaurav Shah

5,2897 gold badges45 silver badges74 bronze badges

1 Comment

Balaji Kandasamy Over a year ago

after that I want to concate as I mentioned in question, thats the main thing bro.

Collectives™ on Stack Overflow

Spliting an array value and concatinating the array value in php

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related