Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a column of data that contains NULLS and "white space" and I need the "white space" to be identified in some way so I can sort them out and to be able to count the NULLS and "white space".
In my LOAD script I am using:
SET NullValue = '<Unknown>';
NullAsValue *;
Below are the results in the INCIDENT TTF DEADLINE TIMESTAMP field which is a Date field
Suggestions on how to get the "white space" identified?
Thanks!
Dan
Hi Dan,
A trick could be If(Len(<field>) > 0 AND Trim(<field>) = 0, <White Space>, [INCIDENT TTF DEADLINE TIMESTAMP]) AS [INCIDENT TTF DEADLINE TIMESTAMP]
Regards;
H