NullInterpret

The defined symbol will be interpreted as NULL when it occurs in a text file, Excel file or an inline statement. This is a user-defined variable.

Syntax:  

NullInterpret

Examples:  

set NullInterpret=' ';

set NullInterpret =;

will not return NULL values for empty cells in Excel, but it will for a CSV text file.

set NullInterpret ='';

will return NULL values for empty cells in Excel.