How to remove empty line in the data?

[florayaoyao]

Hi All, 

I have no idea how to remove the empty records, please see example below....  the data is in the TEXT format.   Please help and advise. 

Big thanks! 

Flora 

[DataBlender · Accepted solution]

Hi @florayaoyao

A filter with the expression:

!IsEmpty([CUST NO])
AND
!IsEmpty([CUST NAME])
AND
!IsEmpty([CONTACT SITE ID])

(etc. until it is specific enough not to remove genuine records)

would give you all non-blank rows from the true output of the filter

[florayaoyao]

Thank you! This works perfectly!   :)