# CSV-Filter fails converting Strings to Integer with greater value than 10

**URL:** <https://discuss.elastic.co/t/csv-filter-fails-converting-strings-to-integer-with-greater-value-than-10/57032>\
**Category:** Logstash\
**Created:** [August 2, 2016, 4:04pm UTC](https://discuss.elastic.co/t/csv-filter-fails-converting-strings-to-integer-with-greater-value-than-10/57032 "2016-08-02T16:04:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![marv](https://avatars.discourse-cdn.com/v4/letter/m/8e8cbc/32.png) [@marv](https://discuss.elastic.co/u/marv)\
**Post date:** [August 2, 2016, 4:04pm UTC](https://discuss.elastic.co/t/csv-filter-fails-converting-strings-to-integer-with-greater-value-than-10/57032/1 "2016-08-02T16:04:48Z")

</div>

Hi Guys,

I have a problem parsing a simple csv-file with logstash and the csv filter.  
The parsing works fine until a certain point. I have all fields present that I would exspect. As I want to visualize this data in Kibana especially the numerical data, I did learn from my past experience with logstash that you have to explicit convert your present fields from Strings to Integer.  
So far so good.

My filter looks like this:  
filter {  
csv {  
columns =\> ["project","id","mantis-link","summary","status","category","target\_version","relations","relCount"]  
separator =\> ","  
skip\_empty\_columns =\> "false"  
}  
if [relCount] {  
mutate {  
convert =\> ["relCount", "integer"]  
}  
}  
}

This works fine.  
BUT if the value of the relCount field ist greater than 9, i get a csv-parse failure and I have no clue why. I can reproduce it every single time.

Thanks in advance and I appreciate your help.

---

<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:** [July 6, 2017, 4:45am UTC](https://discuss.elastic.co/t/csv-filter-fails-converting-strings-to-integer-with-greater-value-than-10/57032/2 "2017-07-06T04:45:17Z")

</div>


