If I try to read in a .csv file with double quotes surrounding text, nothing gets loaded.
Double quotes are commonly used to enclose text, especially if the field contains a comma. The preceding sentence would cause the .csv file to fail if it didn't have double quotes around it, because of the comma.
Excel, OpenOffice SCalc, etc create .csv files this way. (OpenOffice handles cells that have line breaks in them, Excel doesn't)
How do I import this kind of .csv file?
Here are two lines from the Demo Script 22 data file, converted to have quotes. It fails to load in DJuggler Personal v2.2.11
"Date","Open","High","Low","Close","Volume","Adj Close","Note"
"2008-01-18","30.52","30.52","30.52","30.52","000","30.52","Double quotes are commonly used to enclose text, especially if the field contains a comma."
|