Hi there,
our data is in a csv file with a “notes” field for free text information. The notes can contain ' or " or \tab or anything (since is a free text field) as long as xls allows it.
Using QUOTE="double" etc can handle one case but not all the cases. Any way to handle this without writing some pre-processing code?
Thanks,
John