importing a csv file with quotes...

[minerb]

I'm sure this is posted somewhere but I cant find it using the search function here...  what I am doing seems very simple and if someone could help me that would be great.

When importing my csv file there are some fields that have a sub list also sperated by coma's and are defined by quotes...  An example row would look like this...

mazda,2003,m3,red,"ac,ps,pw,pb","img.com,img2.com,img3.com"

I want to have the values returned like this

mazda
2003
m3
red
ac,ps,pw,pb
img.com,img2.com,img3.com

thanks for the help and appologies if its been posted a million times before.

[Adam Cameron.]

You're better off using Google to search these forums, rather than the inbuilt search (this applies to most websites, really).

Um, Ben Nadel discussed this sort of thing on his blog, and I seem to recall testing his solution for this fairly thoroughly, and it worked.

Google that, maybe:

http://www.google.co.uk/search?q=ben+nadel+blog+csv

--

Adam

[Owainnorth]

Adam just saved me a post, but I'd already clicked reply so I felt obliged to write something.