# Not able to parse the data having quote in middle in csv file

**URL:** <https://discuss.elastic.co/t/not-able-to-parse-the-data-having-quote-in-middle-in-csv-file/96210>\
**Category:** Logstash\
**Created:** [August 8, 2017, 7:40am UTC](https://discuss.elastic.co/t/not-able-to-parse-the-data-having-quote-in-middle-in-csv-file/96210 "2017-08-08T07:40:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![deepanshu\_mittal](https://avatars.discourse-cdn.com/v4/letter/d/c6cbf5/32.png) [@deepanshu\_mittal](https://discuss.elastic.co/u/deepanshu_mittal)\
**Post date:** [August 8, 2017, 7:40am UTC](https://discuss.elastic.co/t/not-able-to-parse-the-data-having-quote-in-middle-in-csv-file/96210/1 "2017-08-08T07:40:48Z")

</div>

Hi,

I am trying to parse csv file in logstash but it is failing some messages as some field contains double quotes either at start or middle of mesage.

Eg:  
4491750\*\*,\*\*"CRITICAL: Value for OSCS - Sydney aucom-east-1 reachability Failed in ThousandEyes. Packet Loss \xB3 25%"" is 1",\*\*\*\*Critical,[cqclc10mp020.usdc2.oraclecloud.com](http://cqclc10mp020.usdc2.oraclecloud.com),2017-06-27T16:06:26.000+00:00,2017-06-27T16:06:26.000+00:00,host\r  
564126, **The value of Elasticsearch match pattern No Response from ZFS is 84 . Query:"_No response from ZFS" AND "unable to set luns property_"** ,Critical,compute-em2-z18,2017-01-30T20:15:09.000+00:00,2017-01-30T20:45:30.000+00:00,oracle\_nimbula\_site

The bold data is coming up in one field for successful mesage but if message is as shown above is giving error.

Can you please on how to parse these.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 5, 2017, 7:40am UTC](https://discuss.elastic.co/t/not-able-to-parse-the-data-having-quote-in-middle-in-csv-file/96210/2 "2017-09-05T07:40:58Z")

</div>

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