Code: Select all
," ",
If I change it so that the data is empty quotes, it is handled just fine.
Code: Select all
,"",
For those who are encountering this, the following sed script/command will fix up your data (I got sed and other unix commands from http://www.cygwin.com). It is quoted to suite the windows command shell. May need modification for unix/linux shells.
Code: Select all
sed "{s/\"\ \"/\"\"/g}"
-Luke