Forum Discussion

alex_panganiban's avatar
alex_panganiban
Contributor
2 years ago
Solved

CSV Parsing Error, More Columns Than Data

I am experiencing a parsing error that I would like to be able to gracefully handle before the data streams into the CSV Parser snap. We receive a file from a partner where the last row doesn't actually contain any data, but instead, it has a hidden character <0x1a>. See the attached file and screenprint. The result is that a "more columns than data" parsing error is generated.

We are removing BOM's prior to the CSV Parser. I was wondering if someone can suggest a similar technique for removing this <0x1a> character in the last row. I prefer to proactively code for this condition prior to the CSV Parser, so that in the case there are valid "more columns than data" in other files or on other rows, that they will not ignored by our exception logic.

 

Thanks, Alex

 

3 Replies

No RepliesBe the first to reply