Skip to main content
M
minerb
Participant
April 14, 2011
Question

importing a csv file with quotes...

  • April 14, 2011
  • 1 reply
  • 377 views

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.
    This topic has been closed for replies.

    1 reply

    A
    Adam Cameron.
    Inspiring
    April 14, 2011

    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
    Owainnorth
    Inspiring
    April 14, 2011

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

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices