Ability to ignore specified characters when performing data import
Ran into a problem importing CSV with quoted strings. This is the row that has an issue -
Code: Select all
"24","Automobile Magazine","http://en.wikipedia.org/wiki/Automobile_Magazine_All-Stars","","Automobile Of The Year","y","\"BMW has produced a car that is the gold standard for its class, something that all other automakers feel they have to measure up to.\"","2006"
The importer has a problem with the escaped quote that can be seen right before BMW above. I think it is standard practice to do this, but no 100% sure. In any case is their a way to set up the import wizard to properly import the quoted escaped style strings?