When I export a csv file from my database and I want to loop over the records, then KR does one extra loop at the end.
Basically many database systems when exporting use the csv format with an empty line at the end.
KR cannot handle this and runs one extra time for the empty line.
This blocks me in further automating.
I now have to run KR line per line in the csv manually.
Can’t you edit the file?
An external process could be used to trim extraneous whitespace.
Same question as Russ, can’t you manually remove the last line from the file?
Yes, but isn’t that precisely why we use KR to automate work?
Now I have to manually open the csv file, remove the last line, save it, close it.
I need to run this multiple times per day, manually, defeating the enitre purpose of automation…
Okay I got your point, I thought you were doing this:
which is a rather extreme solution for the problem instead of just deleting the final line in the CSV file.
But thank you for your report, we’ll fix it and inform you when there’s something new.
I added empty lines to my data file but cannot reproduce this issue. Can you help provide a sample data file where this problem is observed? Do you mean an empty line or a line of white spaces and commas combined?
Need to use text or notepad++ to open, manually delete the last line
Can you provide a sample CSV file with this problem? I tried this on my side and I haven’t been able to reproduce it yet.
i use recoder
