Loading CSV with Quotes

[roei61]

Hi All,

I have a csv file that I need to load to a table in PowerPivot.
the file contains some strings and in one column the string contain quotes sign in it.
I noticed that the quotes are cutting the rest of the string.
Does somebody has an idea how I can load the file include the quotes?

Thanks,
Roei

 

[scottsen]

hmm...

So, there isn't actually a definitive "standard" on what it means to be a properly formatted csv file. If power pivot is having a tough time with it, you are going to have to do something else. Things you could try:

* bring into excel first, and "massage" it
* try Power Query
* Edit the file by hand first, with an editor or automated tool

The normal escape for a quote inside a string is to send 2 quotes, so "I am 6'3" tall" becomes "I am 6'3"" tall"