# CSV filter last field add all information also with delimiter

**URL:** <https://discuss.elastic.co/t/csv-filter-last-field-add-all-information-also-with-delimiter/65877>\
**Category:** Logstash\
**Created:** [November 12, 2016, 1:46pm UTC](https://discuss.elastic.co/t/csv-filter-last-field-add-all-information-also-with-delimiter/65877 "2016-11-12T13:46:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hans](https://avatars.discourse-cdn.com/v4/letter/h/e19b73/32.png) [@Hans](https://discuss.elastic.co/u/Hans)\
**Post date:** [November 12, 2016, 1:46pm UTC](https://discuss.elastic.co/t/csv-filter-last-field-add-all-information-also-with-delimiter/65877/1 "2016-11-12T13:46:52Z")

</div>

Hi, I am using the CSV filter however the file I have should only have 6 fields where the last field is a string. in this string field however the deliminator can occur, now this field is split again. How can I place all the information only in the 6 fields and force the last information all into one field?

Here is an example CSV file input:  
`2016-11-01 09:13:41,9,447590345033,25539759,11,/172.29.54.12:34546,1,Your airtimMBDataBundle: * MB`

Here is an example of my filter :  
csv {  
columns =\> [  
"Date\_Time",  
"Nr.",  
"Call",  
"Called",  
"Code",  
"String"  
]  
separator =\> ","  
remove\_field =\> ["message"]  
}

The expected output would be:  
`Date_Time = 2016-11-01 09:13:41 Nr. = 9 Call = 447590345033 Called = 25539759 Code = 11 String = /172.29.54.12:34546,1,Your airtimMBDataBundle: * MB`

---

<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:** [December 10, 2016, 1:46pm UTC](https://discuss.elastic.co/t/csv-filter-last-field-add-all-information-also-with-delimiter/65877/2 "2016-12-10T13:46:55Z")

</div>

Closed on December 10, 2016, 1:46pm UTC

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