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

[Anonymous]

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 !!

[Anonymous · Accepted solution]

hi,
Give footer value = 1.
regards
laurent

[Anonymous]

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

[Anonymous]

you're welcome