Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Unwanted quote marks in csv output when input data contains apostrophes.

ppatane
8 - Asteroid
‎05-31-2023 04:11 PM

In my workflow, the data coming in has apostrophes in some business names and in some last names. The data is being output as a pipe delimited csv file.  On the fields that have an apostrophe in them, they get wrapped in quotes.  All the other rows and fields are fine when there are no apostrophes.  I have tried exporting as ISO and as Unicode, but I still get the quotes. I cannot use the never option in quote output fields as it is not allowed with a delimiter.

Any ideas as to why this is happening?

Labels:
Reply
0 Likes
3 REPLIES 3
flying008
14 - Magnetar
‎05-31-2023 05:20 PM

Hi, @ppatane 

 

Maybe you can upload sample data to explain your problem?

Reply
0 Likes
ppatane
8 - Asteroid
‎06-01-2023 09:24 AM

I will create a dummy upload as the real data is highly confidential.  Will upload soon

Reply
0 Likes
ppatane
8 - Asteroid
‎06-05-2023 11:15 AM

Was able to use the Never option on this workflow.  Wasn't able to use it previously with a delimiter specified.  Not sure what the difference was.

Reply
0 Likes
go to user group event calendar
Labels