Need double quotes around text fields in .csv output

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?

Output

Accepted answers

DanielG

'"' + ToString([Field_That_Needs_Quotes]) + '"'

All comments

acarter881

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++:

test csv thing.yxmd

cjaneczko

Can you use a formula tool a the end before your output?

'"' + [Field_That_Needs_Quotes] + '"'

DanielG

@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.

CSVworkflow.yxmd

DanielG

'"' + ToString([Field_That_Needs_Quotes]) + '"'

tlhoyt

I tried @DanielG response, and it looks right in Alteryx. But when I open the exported file in text editor, it looks like this:

DanielG

@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.

tlhoyt

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703