[blank] will not be found

[peisenrot]

hello,

in my load script I have the line 

LOAD
....
if(CostCenter='[blank]','blank',left(CostCenter,10)) as CostCenterNumber,

...

the '[blank]' is not found when loading no value is loaded at the position. I checked if there is a spelling error but with copy & paste not seen. Any idea how to load the field? When I load the complete CostCenter [blank] is loaded. but not if I would like to have only left.

best regards

Pia

[marcus_sommer · Accepted solution]

This '[blank]' may not really existing else be just a visually replacement for NULL like the dash-char '-' in Qlik. You may just look with an editor like Notepad++ in your source-data or if it's not possible you store these data in the script as csv and looking then into the file.

Quite probably there is no value and this could you check with:

if(len(trim(Field)), 'blank', ...)