Assigning default value to a field

Hello

I am new here and trying to load data from delimited file into MySql database
Some of my fields are mandatory but in incoming file the are blank
What I want to do is populate my tables with default values when source field is empty
Can you please let me know how I can make this work.

Marcus

The answer is very simple use IsNull function

Attached screenshot explains everything

Mike