Quote:
Originally Posted by cas206
I have a source of XML with content I wanted to import. I used my very basic introductory level skills in XSLT to make the CSV to import. My biggest snag was some of the text contained the delimiter (comma). So I enclosed every text field with quotes. But then some of the text also included quotes which messed up the import. For example, the Mind Flayer innate spell charm gives example commands enclosed in double quotes and with comma's. Some web searching quickly found a way for me to add some XSLT to change the double quotes to single quotes which fixed the problem.
So I don't require any changes. However, you did ask about work-arounds, soooo.... an option to delimit by tabs...or something else, might have helped with this.
|
Changing delimiter might be possible.
You can go back to double quote by using two double quotes together within the CSV file.
e.g.
Special rate "1.79"
becomes
"Special rate ""1.79"""
(nicked from
https://gpdb.docs.pivotal.io/43180/a...ted-files.html)