Create two dimensional array from string, but ignore a specific character [duplicate]

Question

this is my string, and I want it to convert into 2D Array.

[email protected];"Hi ;John";man;405089;

[email protected];Hi Sarah;woman;405089;

And I want to create array from this. I fount this code:

$ret = array_map (
  function ($_) {return explode (',', $_);},
  explode (';', $data)
);

Therefore instead of ',' would be ';' and instead of ';' would be '\n', right?

But It doesn't work correctly yet. If you look once more, there is "Hi ; John"..

I want make this code to ignore everything inside of " ", because there is a semicolon.

Firstly try to split string properly. Then thin about building an array. — Alex
– Alex, Commented Oct 30, 2015 at 9:02
That looks like it could be parsed by CSV-handling functions, specifying ; as the field separator. — deceze
– deceze ♦, Commented Oct 30, 2015 at 9:05

Saeed · Accepted Answer · 2015-10-30 09:13:07Z

4

First remove characters between and including ", then run your function. Here is a one line code to remove "Hi ; John" from your string:

$result = preg_replace('/\".*?\"/', '', $subject);

\" matches the character " literally
.*? matches any character (except newline), Quantifier: *? Between zero and unlimited times, as few times as possible, expanding as needed [lazy]
\" matches the character " literally

answered Oct 30, 2015 at 9:13

Saeed

6716 silver badges12 bronze badges

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

Comments

danjam · Accepted Answer · 2015-10-30 09:05:22Z

4

Instead of explode, take a look at str_getcsv.

This will handle your case with the semicolon inside the quotes if you specify a delimiter, like so.

str_getcsv($_, ';')

answered Oct 30, 2015 at 9:05

danjam

1,0629 silver badges13 bronze badges