Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Unwanted quotations appearing in exported string

stuan
5 - Atom

I am trying to write a table with strings within the quotation, which I then export to a csv file. The image shows what the string looks like before exporting to the file (and what I want the string to appear as). After exporting, it appears like this: 

 

""IB-FTL""[shape=""cds""];

 

Everything that should be in quotations has two quotations - so "" instead of ". Is there a change I can make that would prevent the double quotations from appearing, keeping only the single quotations?

3 REPLIES 3
CharlieS
17 - Castor
17 - Castor

Hi @stuan 

 

Have you tried adjusting the settings on the Output fool that write the .csv? Also, does it have to be .csv?

 

20200701-CSVQuotes.png

stuan
5 - Atom

I would like a text output, and I think a csv is the way to go about that -
although I could be wrong.

I tried setting the "Quote Output Fields" to "Never", but got the error
that "the field cannot contain a delimiter character". I then tried to
change the delimiter to a \t, but I can't have more than one character as a
delimiter. I also tried changing the Code Page to Unicode UTF-8, but that
did not change the quotation error.

stuan
5 - Atom

Solved by setting the delimiter to \0.

Labels