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