Ignore wrong records

[Saraabdi955]

Hi everyone,

I have so many .txt and .csv files. In some of them, there are records that they have more than specific delimiters and I got this message:

"Record #1219: Tool #2: Too many fields in record #57"

How to ignore the wrong records and read all the file to end?

[Saraabdi955]

Hi @danilang 

Thanks for your response.

Actually the main question is "How to ignore and pass the wrong record in a dataset?"

Some times these are few wrong records in hundreds records. Is there any solution for this problem?

[binu_acs]

@Saraabdi955read all the records at once then filter out unwanted records