Hi @Comunity
I am performing audience export. Email address field in audience export, where some the values are null in exported csv file. When SFMC automation takes this file, it gives error where emailaddress = 'null'.
Could you suggest how can i make this field as blank ?
Already tried below.
1. Added calculated field and used both formulas
iif(replacestr(email_address, ",", "") == 'null', '', replacestr(email_address, ",", ""))
coalesce(replacestr(email_address, ",", ""), "")
both are still giving null text in export.
Thanks in advance.
Best Regards,
Santosh
