Empty Strings - How to filter them out

[#1]

I have a char field that either has a 10 digit number in it i.e. (0000658978) or it is empty.  After loading the table and then when I try and do a resindent load on this field where it's not equal to an empty string it does not weed out the lines where this field is empty.  Can anyone assist on the script to deal with this situation?  Thanks, Sean

[#2]

When you load this field into a list box does this empty string appear as a selection option?

[ToniKautto]

Sounds like you should get either blank strings or null values in your data. If this is the case you can filter on either or both conditions, for example by the principle below.

LOAD

F1

RESIDENT TableName

WHERE not IsNull(F1) AND Len(F1) > 0;

[#4]

In a list box it does not, but in a table I can select it and it will filter the table to show all lines where this field is empty.

[#5 · Accepted solution]

Try:

WHERE len(trim(F1)) > 0

Regards,

Gordon

[#6]

Hi,

While uploading the data go to "Enable Transformation Step" and in the Garbage Tab apply "Conditional Delete"

there you can delete as per you condition,

[#7]

This did not work.  I received the same results.  I also tried a couple of iterations and that did not work as well.the script is:

INNER

JOIN (BillingLine)
Load Distinct
%KEY_VBRP,
[Sales deal_KNUMA_AG]

Resident BillingLine where not IsNull([Sales deal_KNUMA_AG]) and Len([Sales deal_KNUMA_AG]) >0;

[#8]

Can you provide a sample?

[#9]

Ah, that did the trick, thanks much.

[#10]

just check the attached excel file and the table