I noticed in my output file that one of the fields has a comma so I would expect it to automatically output double quotes for that field when the format is comma delimited. The output file I removed all quotes. So, i only need it for fields that have Comma's for instance the address field.
Solved! Go to Solution.
If you have Quote Output Fields set to Auto it should do whate you want
Setting the delimeter to \0 stops Alteryx putting any delimeter into the file (i.e. all columns would become a single value)..
Auto will hence not add any quotes as it doesnt find any delimeters in the string.
The easiest way to get quotes around strings with this setting would be to use a multifield formula to add the quotes.
Have attached a demo
Is there a formula that i can use for the address field?
Can you attach a sample of data and what you want to get out?
That's not going to work based on my configurations. I don't want to change my configurations because everything works except if there's a comma in a field of this comma delimited file.
I'm trying to use a filter. I want it to search for a , then use double quotes in that field if it finds a comma. I started it below but i need more assistance.
FindString([Address1],",") > -1
Ok, so I added this in a filter and it removed some rows of data. Then i added it to a formula, it seems to work but now the it add " " to all data in the address field insted if field contains a comma. Also, I received an error
IIF(Contains([Address1],','),'"'+[Address1]+'"',[Address1])
with contains in the expression. I had to change it to findstring because contains is not an option in 9.5.
Since i have 9.5 version, contains is not an option to use for this version to use this expression.
IIF(Contains([Address1],','),'"'+[Address1]+'"',[Address1])