CODEWITHSUNDEEP
phpcsvtext-parsingdouble-quotesdelimited
Brandon G
Brandon G

Reputation: 2893

Parse comma-separated string where some substrings are wrapped in double quotes

Trying to parse a csv file that has all the data wrapped in double quotes, because there may be commas in the double quotes.

Looks like this: 

$songs = '"1, 2, 3, 4 (I Love You)","Plain White T's","CBE10-22",15,"CBE10-22","","","CB",984,"","10/05/10"';

$regResult = preg_match( "", $songs, $matches );

I can't figure out a regex that will return the data between the quotes as the matches. I'm sure there is some regex master that can help me with this.

Upvotes: 2

Views: 1199

Answers (1)

goat
goat

Reputation: 31813

you dont need no stinkin regex to parse a csv file in php.

see fgetcsv() and str_getcsv()

Upvotes: 8

Related Questions