Q:

Text File Input ignore line of tabs

I have a job in Pentaho with a Text File Input step reading from a tab delimited text file.  Sometimes when this file is given they have lines that are empty of data but the row is filled with tabs because they copied empty lines in excel.  Below is a screen shot of the 'empty' rows in Notepad++.

Is there a way to ignore lines like this?  I tried adding a filter entry with Filter string = number of tabs, Filter position = 0, Stop on filter = Y, Positive match = Y.  This filter didn't seem to have any effect.
When the job runs it treats all of these as NULL records which makes sense but then this causes the next job a Table output to fail.  If there is not a way to fix this with a text file input is there another job which can easily clean-up the bad records?

A:

When I did more debugging I found out that the Filter tab did have the logic to achieve what I was looking for.  Instead of Filter string = number of tabs, Filter position = 0, Stop on filter = Y, Positive match = Y it needed to have Positive match = N.  After this change then it started working correctly.

