Rearrange array with multiple keys

Question

I have an array:

Array
(
    [12] => USD
    [13] => 10150.00
    [14] => 9850.00
    [15] => SGD
    [16] => 8015.40
    [17] => 7915.40
    [18] => HKD
    [19] => 1304.60
    [20] => 1288.60
    ...
)

What I want to do is arrange it to be like this:

Array
(
    [USD] => Array
             (
                 [Buy] => 10150.00
                 [Sell] => 9850.00
             )
    [SGD] => Array
             (
                 [Buy] => 8015.40
                 [Sell] => 7915.40
             )
    [HKD] => Array
             (
                 [Buy] => 1304.60
                 [Sell] => 1288.60
             )
    ...
)

I've done a lot of array functions but still stuck with this.

You need to iterate over it and create desired structure, there is no ready function for that. — dev-null-dweller
– dev-null-dweller, Commented Jul 13, 2013 at 16:48
@frozenade, your question being answered, may you please mark one answer as accepted? — Stéphane Bruckert
– Stéphane Bruckert, Commented Aug 12, 2014 at 14:08

Alix Axel · Accepted Answer · 2013-07-13 16:58:15Z

5

If the suite of fields remains the same as:

Currency
Buy value
Sell value

then, you can do:

$old_array = array('USD', 123.00, 432.34, 'SGD', 421.41, 111.11);
$new_array = array();

for ($i = 0; $i < count($old_array); $i = $i + 3) {
    $new_array[$old_array[$i]] = array
    (
        'Buy' => $old_array[$i + 1],
        'Sell' => $old_array[$i + 2]
    );
}

edited Jul 13, 2013 at 16:58

Alix Axel

155k99 gold badges406 silver badges509 bronze badges

answered Jul 13, 2013 at 16:51

Stéphane Bruckert

23.1k15 gold badges102 silver badges136 bronze badges

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

1 Comment

Alix Axel Over a year ago

You probably need to do $i_currency = $old_array[$i] tho, and then just use $i on the buy/sell indexes.

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

Demo

$data = array
(
    'USD',
    '10150.00',
    '9850.00',
    'SGD',
    '8015.40',
    '7915.40',
    'HKD',
    '1304.60',
    '1288.60',
);

$result = array();

while (is_null($value = array_shift($data)) !== true)
{
    if (preg_match('~^[A-Z]{3}$~', $value) > 0)
    {
        $result[$value] = array
        (
            'Buy' => array_shift($data),
            'Sell' => array_shift($data),
        );
    }
}

print_r($result); // transformed array

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jul 13, 2013 at 16:49

Alix Axel

155k99 gold badges406 silver badges509 bronze badges

1 Comment

frozenade Over a year ago

That's amazing. +1 for all. Thank you very much for Stéphane Bruckert and Alix Axel. Now, I just convert it to xml service.

mickmackusa · Accepted Answer · 2021-01-21 05:59:26Z

0

Since the structural pattern of your input array is reliable, I can provide a functional approach (no for/while loops, no new variables in the global space).

Code: (Demo)

var_export(
    array_reduce(
        array_chunk($input, 3),
        function($carry, $item) {
            $carry[$item[0]] = ["Buy" => $item[1], "Sell" => $item[2]];
            return $carry;
        },
        []
    )
);

Output:

array (
  'USD' => 
  array (
    'Buy' => '10150.00',
    'Sell' => '9850.00',
  ),
  'SGD' => 
  array (
    'Buy' => '8015.40',
    'Sell' => '7915.40',
  ),
  'HKD' => 
  array (
    'Buy' => '1304.60',
    'Sell' => '1288.60',
  ),
)

array_chunk() creates an array of 3 consecutive elements from your input array.
array_reduce() is used to form a new, associative output array.

edited Jan 21, 2021 at 5:59

answered Apr 30, 2017 at 14:58

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

Collectives™ on Stack Overflow

Rearrange array with multiple keys

3 Answers 3

1 Comment

Demo

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related