Topic: Record Cleaner problems
Hello
I'm using Record Cleaner and get some error messages, which are not as helpful as they could be.
After starting the validation process, I get error messages like: "There was an errror in your data file at about line: 19737. This could well be stray quotation mark. The CSV appears corrupt near record 19736 field 11 at position 2769. Current raw data:....."
Then a long text of record sets follows, where I don't know, if the affected record is at the beginning, at the end or somewhere in the middle. From this message I have difficulties to find out, which record is affected. It would be good, if the error message would let me know the field name and the value of the unique identifier. That would make it much easier to find the record in the original data. In the above mentioned example it doesn't help, even to delete that, what I think to be records 19735, 19736 and 19737.
Regards,
Wolfgang