How to check for the blank lines in an excel file.

anshumangupta1206 · Post by **anshumangupta1206** » Thu Feb 02, 2006 3:54 am

Hi,
I am processing an excel file through DataStage. The file format is like it has blank line after each row. I want that if there is any blank line I can reject that record otherwise process it. Could anybody tell me how i shd check this.

Sunshine2323 · Post by **Sunshine2323** » Thu Feb 02, 2006 4:24 am

Hi Anshuman,

Since you are working on the Unix Server you might be converting the excel files to csv.

While reading the files using the sequential stage you can give the set the Incomplete Column property to Discard and Warn.
This will lead to all the blank lines being eliminated.
Also when you run the job you will get warnings in the director.

Other way is using the transformer you can concatinating the columns and checking the len to be greater then 0 or checking that they are not equal to blank('')

This can be achieved in many possible ways.

Hope this helps

anshumangupta1206 · Post by **anshumangupta1206** » Thu Feb 02, 2006 5:06 am

Thanks buddy!!
It is working.