How do you have the custom format automatically add quotes when there's a comma in a field

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.

Output

Accepted answers

jdunkerley79

I think this should work:

IIF(REGEX_Match([Address1],'.*,.*'),'"'+[Address1]+'"',[Address1])

Have attached a file in v9 format I think.

One other option is to add contains to your function library. Download this https://raw.githubusercontent.com/jdunkerley/AlteryxFormulaAddOns/35c93ee1da2a57a478018d7ca395a0c2e545be46/StringUtils.xml and save to C:\Program Files\Alteryx\bin\RuntimeData\FormulaAddIn

AddCommas.yxmd

All comments

jdunkerley79

If you have Quote Output Fields set to Auto it should do whate you want

Dom

Auto doesn't work when since my delimiter is set to \0. I have to have it set this way because with , setting it makes eveything in one string with Auto setup. see layout screenshot

screenshot.bmp

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235