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.
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
Thank you! This expression worked
IIF(REGEX_Match([Address1],'.*,.*'),'"'+[Address1]+'"',[Address1])
The link you provided errored out