What makes the CSV Iterator stop iterating?

Automise Discussion
1

I have a file that I am using CSV Iterator to loop through.  The first line of the file has data in every field.  The second and third lines do not have data in the FIRST field, but there is data in the other fields.  The fourth line has data in all fields.

The iterator seems to be stopping after processing the second line of data.  Does the CSV Iterator stop when it encounters a line with no data in the first field?  Or is something else going on?

Thanks,

Jonathan

Build 4.0.0.631

2

More information: I removed lines 2 and 3, and so the second line of the file has all fields filled in…but the iterator still stops after line 1. It goes to line 2 in the log, but then skips the processing of line 2 and ends. No idea why.

3

Never mind. It turns out that my user was saving the file with a CSV extension, but not actually in CSV format, so the newlines were missing. The whole file was a single line of text, which is why the iterator stopped after line 1. Feel free to delete this whole topic if you wish, or let me know how to do it.