Divide string into associtive array

Question

I have a string:

$string = 'A0695/16 NOTAMN Q) EHAA/QARLT/I /NBO/E /000/999/5155N00430E073 A) EHAA B) 1605260001 C) 1608260900 EST E) REF AIP NETHERLANDS ENR 3.2 UT601 ADD TO ROUTE REMARKS: NOT AVBL FOR TRAFFIC DEP/ARR ETNG, EDDK AND ETNN DURING THE OPENING OF EHEH 0600-2300 (0500-2200). THESE FLIGHTS WILL HAVE TO REROUTE.';

I would like to split this string into an associative array.

$result['Q)'] = 'EHAA/QARLT/I /NBO/E /000/999/5155N00430E073';
$result['A)'] = 'EHAA';
$result['B)'] = '1605260001';
$result['C)'] = '1608260900 EST';

etc.

I managed to get it into an array with:

$result = preg_split("/.\)/", $string);

It gives me an array but I need the keys to be 'a)', 'b)' etc.

Can anyone help me with this?

It might be better to take a step back an look at how you created that string, maybe that would be a better place to make a change — RiggsFolly
– RiggsFolly, Commented Aug 6, 2016 at 15:15

RomanPerekhrest · Accepted Answer · 2016-08-06 16:25:23Z

2

The solution using preg_match_all function with specific regexp pattern(named submasks) and array_combine function(to get a respective key/value pairs):

$string = 'A0695/16 NOTAMN Q) EHAA/QARLT/I /NBO/E /000/999/5155N00430E073 A) EHAA B) 1605260001 C) 1608260900 EST E) REF AIP NETHERLANDS ENR 3.2 UT601 ADD TO ROUTE REMARKS: NOT AVBL FOR TRAFFIC DEP/ARR ETNG, EDDK AND ETNN DURING THE OPENING OF EHEH 0600-2300 (0500-2200). THESE FLIGHTS WILL HAVE TO REROUTE.';

preg_match_all("/(?<k>[A-Z]\)) (?<v>.+?)(?= [A-Z]\)|$)/", $string, $matches);

// 'k'/'v' are key/value
$result = array_combine($matches['k'], $matches['v']);

print_r($result);

The output:

Array
(
    [Q)] => EHAA/QARLT/I /NBO/E /000/999/5155N00430E073
    [A)] => EHAA
    [B)] => 1605260001
    [C)] => 1608260900 EST
    [E)] => REF AIP NETHERLANDS ENR 3.2 UT601 ADD TO ROUTE REMARKS: NOT AVBL FOR TRAFFIC DEP/ARR ETNG, EDDK AND ETNN DURING THE OPENING OF EHEH 0600-2300 (0500-2200). THESE FLIGHTS WILL HAVE TO REROUTE.
)

edited Aug 6, 2016 at 16:25

answered Aug 6, 2016 at 15:27

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

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

2 Comments

Casimir et Hippolyte Over a year ago

Your way is clearly the best. Note that you can remove the option PREG_SET_ORDER and build the result without using foreach, like this: $result = array_combine($matches['k'], $matches['v']);

RomanPerekhrest Over a year ago

@CasimiretHippolyte, thanks for the useful hint. I've simplified the answer

alzee · Accepted Answer · 2016-08-06 15:55:00Z

Another goofy solution for the goofy format, because why not.

  $string = 'A0695/16 NOTAMN Q) EHAA/QARLT/I /NBO/E /000/999/5155N00430E073 A) EHAA B) 1605260001 C) 1608260900 EST E) REF AIP NETHERLANDS ENR 3.2 UT601 ADD TO ROUTE REMARKS: NOT AVBL FOR TRAFFIC DEP/ARR ETNG, EDDK AND ETNN DURING THE OPENING OF EHEH 0600-2300 (0500-2200). THESE FLIGHTS WILL HAVE TO REROUTE.';

  $foo = preg_split('/([A-Z]\)) /', $string, 0, PREG_SPLIT_DELIM_CAPTURE);
  $ret = [];
  foreach (range(1, count($foo) - 1, 2) as $i)
  {
    $ret[$foo[$i]] = $foo[$i + 1];
  }
  print_r($ret);

Prints:

Array (
    [Q)] => EHAA/QARLT/I /NBO/E /000/999/5155N00430E073 
    [A)] => EHAA 
    [B)] => 1605260001 
    [C)] => 1608260900 EST 
    [E)] => REF AIP NETHERLANDS ENR 3.2 UT601 ADD TO ROUTE REMARKS: NOT AVBL FOR TRAFFIC DEP/ARR ETNG, EDDK AND ETNN DURING THE OPENING OF EHEH 0600-2300 (0500-2200). THESE FLIGHTS WILL HAVE TO REROUTE. )

Casimir et Hippolyte · Accepted Answer · 2016-08-06 15:44:16Z

0

More fanciful than efficient but it does the job:

$p = preg_split('~(?<!\S)([A-Z]\))\s+~', $string, -1, PREG_SPLIT_DELIM_CAPTURE);
$result = [];
if (count($p) > 1) {
    unset($p[0]);
    while($p) { 
        $result[array_shift($p)] = array_shift($p);
    }
}

print_r($result);

answered Aug 6, 2016 at 15:44

Casimir et Hippolyte

90k5 gold badges102 silver badges131 bronze badges

Collectives™ on Stack Overflow

Divide string into associtive array

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related