PHP split CSV line, regex

[johnnnn]

I'm trying to read data from a CSV, and need to know a regular expression to split the line:

Here's what I have so far, but it doesn't work:

PHP Code:

$pattern = '/(,(?: ))/';
$line = preg_split($pattern, $data); 


please do NOT tell me about fgetcsv(), I'm aware of that, but I think using a regex would be easier.

Any suggestions?

Thanks!

[kbluhm]

Why make things more difficult and less efficient? Is there a reason you're avoiding fgetcsv()?

[Martin Kunz]

Hi,

I think regexp for CSV is to complex. Reason: you can use TAB or ,; as
delimiter. I think the escape character and look ahead for the
closing " or ' will kill you. Mainly the parsing of the CSV will
bee very slow.

I use dbTube.org and the native excel format xls. The tool did have
a UI like iTunes. But the source code is included. In this case you can
customize or integrate them seamless in your app.

Greetings