Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to handle Null Values in CSV flie
Could you please provide more descriptive information, maybe an example too? Is your issue with reading a .CSV file with nulls in or storing output as a .CSV ?
Thank you for replay....
I have files Sales data.xls,Sales data.csv.in this file i have CustomerID field .
when every i am using NullDisply,NullInterput,nullasvalue,nullasnull it not wrok.....
how to handle null values in CustomerID.
Hello Prasad,
Prasad Jakkula wrote:
when every i am using NullDisply,NullInterput,nullasvalue,nullasnull it not wrok.....
how to handle null values in CustomerID.
It's not really clear enough to understand your issue. Can you please upload a sample with expected result described?
try checking with IsNull() function to pre-process your data first
Hi,
You can use the function length as well.
len(field_name)<0 as null_field
-Jay
NullInterpret takes a different syntax for csv than for QVD. Try:
Set NullInterpret = '';