We have a problem that I hope has a simple solution. We have a CSV file that is like:
What I would like to be able to do is read the binary data from the ZIPfile read object, and do something like access it in a script file. If I COULD, I could create something like:
HEADERS… LINE #, 1,2,3,4,5
LINE#, input data…
ERROR, Delimiter error on field FOUR on line #…
At the moment, it looks like we can maybe just get the error, and the line #. How can we get the source, or how can I use the script object to capture this data?
We actually have this error now, with a double quote that makes reading data properly unreliable. The ability to put this raw data into a file, and maybe note it in the source, on the fly, to have a process ignore the current changes, would help us a lot.