I want my .csv (with my own named extension) to output with double quotes like the following:
I have selected "Always" for Quote Output Fields. However, my output looks like this:
Does anyone know how to get the output to look like the first picture when I have already selected "Always" for Quote Output Fields?
Solved! Go to Solution.
Hello, @tlhoyt.
Here's my test example (see attached). It seems to be working as intended. Please let me know if this isn't what you're referring to.
Output when opened in Excel:
Output when opened in Notepad++:
Can you use a formula tool a the end before your output?
'"' + [Field_That_Needs_Quotes] + '"'
@tlhoyt - see attached. You have to do what @cjaneczko but also convert to string in formula. I built this change off of @acarter881 's attached example. I tried just converting it to a string and running it through but that doesnt work either.
'"' + ToString([Field_That_Needs_Quotes]) + '"'
I tried @DanielG response, and it looks right in Alteryx. But when I open the exported file in text editor, it looks like this:
@tlhoyt - OK. I apologize. My default view of CSV is via Excel. Which suppresses the extra quotes. @acarter881's workflow does it with just the output settings. As you can see from the screenshot you included, F3 was showing correctly with the quotes around it without making any changes from @acarter881 's version. The "test" field was my mistake due to Excel. The screenshot below is running it with his settings not mine.
I figured it out. I have 2 separate outputs and I was changing one but looking at the other after running (facepalm). Thank you all!