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

[Dom]

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.

[jdunkerley79 · Accepted solution]

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/35c93ee1da2a57a478018d7ca395a0c2e5... and save to C:\Program Files\Alteryx\bin\RuntimeData\FormulaAddIn

[Dom]

Thank you! This expression worked 

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

The link you provided errored out