I'm reading a .csv file using the UniversalDataReader component with quoted strings=true and data policy=Controlled.
This is connected to two output ports:
1) Port 0 (output) for good records
2) Port 1 (logs) for the bad records, using the Error Metadata.
The input records contain some embedded quotes (e.g. ["123","John ""Long John"" Silver","Pirate"] which cause a "Parsing error: Bad quote format" to appear in the Console output. However, no corresponding records are coming out of Port 1.
Am I doing something wrong or is that the expected behavior? I would really like to have the bad records be saved to a separate file for further processing.
This is connected to two output ports:
1) Port 0 (output) for good records
2) Port 1 (logs) for the bad records, using the Error Metadata.
The input records contain some embedded quotes (e.g. ["123","John ""Long John"" Silver","Pirate"] which cause a "Parsing error: Bad quote format" to appear in the Console output. However, no corresponding records are coming out of Port 1.
Am I doing something wrong or is that the expected behavior? I would really like to have the bad records be saved to a separate file for further processing.
-
Hi, I do not see a problem and Clover could properly parse the record. Attached you can find the graph that I used to replicate the problem.
Please sign in to leave a comment.
Comments 2