Dealing with nulls coming from CSV file

Guys,

I have a source csv file as below with 4 columns and using double quotes as optional quotes
"Beer","","",,

2nd and 3rd columns are empty strings and last one is NULL. When Advanced ETL Processor reads file and loads it into Teradata table it inserts 2nd and 3rd column as NULL instead of empty string.
Is there a way to handle this case and treat those columns as empty strings?

Thanks,
Sergio

Serg

Please use "If null function" to assign default value to field.
see the picture below