audience export : blank emailaddress give "null"

Hi @2693620 

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