How to remove empty line in the data?

Question

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 Answer

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