Unenclosed quoted field on line 1 - frustrating error message

Hello,
I wanted to share some frustration, and maybe even hope for a solution - the logs are extremely unhelpful when it comes to my specific logstash experience.
Here is an example where logs tell me there is an un-enclosed quote. I checked; double checked, and could not locate such un-enclosed quote that is not handled in this message,
however the parser provides this unhelpful log message and I don't see any problem with the text.

Any advice would be greatly appreciated.

[2018-01-10T15:41:19,908][WARN ][logstash.filters.csv ] Error parsing csv {:field=>"message", :source=>"\"2017-12-17\";\"NA\";\"NY\";\"New York\";\"TEST1\";\"123ZLB\";\"VDI\";\"COMPANY\";\"TEST\";\"10-13-2017\";\"reported_item\";\"0\";\"N\";\"0\";\"N\";\"0.06\";\"0.20\";\"0.49\";\"30.38\";\"0\";\"2.08\";\"2.00\";\"2.08\";\"103.99\";\"0\";\"1.11\";\"552.64\";\"0.20\";\"553.75\";\"1.11\";\"1106.39\";\"0.10\";\"1107.50\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\";\"N\r", :exception=>#<CSV::MalformedCSVError: Unclosed quoted field on line 1.>}

The value of message is show wrapped in double quotes. The last field is "N\r and that is an unclosed quoted field.

1 Like

Thank you !

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.