Forum Discussion

Dhivya_Aroma1's avatar
Dhivya_Aroma1
New Contributor III
6 years ago
Solved

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...
  • dimitri_hristov's avatar
    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