Skipping faulty records in tab delimited file

[fajosa]

Greeting!

Is there a way we can skip faulty records which has special symbols as it fails the whole file while using the CSV parser.

The highlighted record is the one which needs to be removed, or any records which has special symbols which are not accepted by CSV parser.

Appreciate all your help!

Thanks,
F.

[j_angelevski · Accepted solution]

Hi @fajosa,

Go to CSV Parser’s Views tab and change the default behavior of the snap to “Route Error Data to Error View”, this will discard the record that can’t be processed.

[fajosa]

Thank you! that works!