[resolved] How to stop to read a CSV file when first cell of a row is empty

One Star

[resolved] How to stop to read a CSV file when first cell of a row is empty

Hello,
I have to read a CSV file.
The first column is the ID, and others columns contain informations about this ID.
But the last row of my file is a empty row except one column in the middle of the file which contains the line number in that file.
I do not want to consider this line. The "ignore blank lines" of tFileInputDelimited option is not enough because the last line is not empty, but contains just one value.
I would like to test if the id column is empty, in which case I will not take into consideration the entire line.
Have you any idea?

Thanks !!

Accepted Solutions
Seventeen Stars

Re: [resolved] How to stop to read a CSV file when first cell of a row is empty

hi,
Give footer value = 1.
regards
laurent

All Replies
Seventeen Stars

Re: [resolved] How to stop to read a CSV file when first cell of a row is empty

hi,
Give footer value = 1.
regards
laurent
One Star

Re: [resolved] How to stop to read a CSV file when first cell of a row is empty

I could not expect a rapid and effective response!
great thank you !
Seventeen Stars

Re: [resolved] How to stop to read a CSV file when first cell of a row is empty

you're welcome Smiley Wink