Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am extracting data from a source and would want to do the following action before loading the data into QV:
How can this be accomplished in QV before/during the loading process?
Regards.
There is small difference. If you have white spaces, IsNull won't be able to catch them, but Len(Trim()) will. So I find it more useful to use Len(Trim()) instead of IsNull just because I believe white spaces are nulls. If you don't want to take them as nulls, then IsNull() is your function
Thanks once again
Thanks Sunny for the swift and very elegant explanation