XLS null record

deshartman

• May 19, 2009 00:00

• Answered

Follow

Hi, I am reading a XLS file and writing this to a Postgres dB. The problem I have is that the last record written has a null value. I presume that this is to indicate that the last record has been reach. Since there is a varying number of records, I cannot set the last record value.

Is there any way I can avoid this last "null" record being written?

Thanks
Des

• 

  avackova

  • May 19, 2009 07:43

  0

  Comment actions Permalink

  Hello,
  you have empty line in your xls file probably, that is read by clover (manualy removed?). You can put ExtFilter component after reader that allow to pass not null records only.
• 

  deshartman

  • May 19, 2009 23:48

  0

  Comment actions Permalink

  Yep, that did the trick thanks
  :D

Please sign in to leave a comment.