Skip to main content

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 blank values in Excel (but it will for a csv text file)

set NullInterpret ='';

will return NULL values for blank values in Excel (but will NOT for a csv text files)

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!