Making a null value into a real value

[#1]

I'm stuck. How do I turn a null value into something like "Unlabeled" or "Backlog" when I load it from a table in my script?

[#2]

stalwar1‌ idea is a pretty good one. ORD() function will expose if there's a hidden character.

[swuehl]

Try to remove all white spaces, like chr(160):

LOAD @1 as ITMSNumber,

if(Len(Trim(Replace(@1,chr(160),''))) = 0, 'Unlabeled', @1) as [ITMS Type]

FROM

(txt, codepage is 1252, no labels, delimiter is ' ', msq);