# When parsing data I am getting this error

**URL:** <https://discuss.elastic.co/t/when-parsing-data-i-am-getting-this-error/265796>\
**Category:** Elasticsearch\
**Created:** [March 1, 2021, 12:40pm UTC](https://discuss.elastic.co/t/when-parsing-data-i-am-getting-this-error/265796 "2021-03-01T12:40:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![padamrai](https://avatars.discourse-cdn.com/v4/letter/p/3da27b/32.png) [@padamrai](https://discuss.elastic.co/u/padamrai)\
**Post date:** [March 1, 2021, 12:40pm UTC](https://discuss.elastic.co/t/when-parsing-data-i-am-getting-this-error/265796/1 "2021-03-01T12:40:26Z")

</div>

I have a data without columns name and I am giving name of the columns in conf file. I don't know giving this way columns name is correct or not?  
[2021-03-01T17:33:34,741][WARN][logstash.filters.csv][main][7c8e4b1853e62f45feefa30d1a08812903bc9db233255c5ec2cd00588b905f5f] Error parsing csv {:field=\>"message", :source=\>"2020-08-03 09:41:09,923361900066,UFone,"200.00 PKR have been Debited on 03-08-2020, 09:29:26. For assistance call 021-111-627-627." ,8627,1,2020-08-03 09:41:23,DELIVERED,SUCCESS\r", :exception=\>#\<CSV:: **MalformedCSVError: Unclosed quoted field on line 1.\>** }

---

<div class="post-metadata">

**Author:** ![inhinyera16](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/inhinyera16/32/61625_2.png) [@inhinyera16](https://discuss.elastic.co/u/inhinyera16)\
**Post date:** [March 1, 2021, 1:17pm UTC](https://discuss.elastic.co/t/when-parsing-data-i-am-getting-this-error/265796/2 "2021-03-01T13:17:22Z")

</div>

hi.. please attach your logstash configuration file

---

<div class="post-metadata">

**Author:** ![padamrai](https://avatars.discourse-cdn.com/v4/letter/p/3da27b/32.png) [@padamrai](https://discuss.elastic.co/u/padamrai)\
**Post date:** [March 2, 2021, 4:20am UTC](https://discuss.elastic.co/t/when-parsing-data-i-am-getting-this-error/265796/3 "2021-03-02T04:20:14Z")

</div>

input{

```
file{

    path => "C:/Users/Ubaid/Desktop/ElasticSearch/elasticsearch-7.11.1-windows-x86_64/NBP-Aug.csv"

    start_position => "beginning"

    sincedb_path => "Null"

}

```

}

filter{

```
csv{

    separator => ","

    columns => ["Date","Mobile","Telco","Msg","ShortCode","SMSLength","DeliveryDate","DeliveryStatus","Criteria"]

}

grok{

    match => {

        "message" => [

            "bill payment of amount %{NUMBER:billAmount} for Company Name %{NOTSPACE:Name}",

            "Rs.%{DATA:ATMamount} %{NOTSPACE:PaymentType} from ATM",

            "you have successfully %{WORD:login} at",

            "Ledger Bal: %{NUMBER:ledgerAmount}, Available Bal:%{NUMBER:AvailableBal}, Status:%{NOTSPACE:status}",

            "Rs.%{DATA:CreditedAmount} have been %{NOTSPACE:PaymentType} into your account",

            "You have successfully %{NOTSPACE:transffered} PKR. %{NUMBER:transAmount} from Account",

            "Your Complaint number 7221679 is in %{NOTSPACE:ComplaintProcess}"

        ]

    }

}

 mutate {

    convert => {

        "billAmount" => "integer"

        "ATMamount" => "integer"

        "CreditedAmount" => "integer"

        "ledgerAmount" => "integer"

        "AvailableBal" => "integer"

        "transAmount" => "integer"

    }

}

date{

    match => ["Date", "M/dd/yyyy HH:mm:ss"]

    target => "Date"

}

```

}

output{

```
elasticsearch{

    hosts => "http://localhost:9200"

    index => "august-nbp-data"

}

stdout{

    codec => rubydebug

}

```

}

---

<div class="post-metadata">

**Author:** ![padamrai](https://avatars.discourse-cdn.com/v4/letter/p/3da27b/32.png) [@padamrai](https://discuss.elastic.co/u/padamrai)\
**Post date:** [March 2, 2021, 7:30am UTC](https://discuss.elastic.co/t/when-parsing-data-i-am-getting-this-error/265796/4 "2021-03-02T07:30:57Z")

</div>

Please help me to resolve above error. I have attached configuration file as well.  
**exception=\>#\<CSV:: MalformedCSVError: Unclosed quoted field on line 1.\> }**

---

<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:** [March 30, 2021, 7:31am UTC](https://discuss.elastic.co/t/when-parsing-data-i-am-getting-this-error/265796/5 "2021-03-30T07:31:32Z")

</div>

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