Dhivya_Aroma1
6 years agoNew Contributor III
Trim last lines in csv file
Team,
I have a log file in csv format. But the log file contains status information in first 5 lines and last 3 lines.
I can skip the first 5 lines using Skip lines* property in csv parser. But I...
- 6 years ago
Hi,
I tried to recreate the error by parsing the data from the original post, and yes, the CSV Parser threw an error. Still, the desired data from the .csv file were present on the output of the CSV Parser Snap, correctly transformed into JSON format. I too skipped the first 5 lines by using the “Skip lines” property in the CSV Parser.
However, by selecting the “discard error data and continue” option in the drop-down for the Error View in the CSV Parser, the problem disappeared altogether. No error, and the CSV data was correctly parsed.BR,
Dimitri