# Loading csv file data in Elasticsearch with explicite double quote in the beginning and inside of some fields

**URL:** https://discuss.elastic.co/t/loading-csv-file-data-in-elasticsearch-with-explicite-double-quote-in-the-beginning-and-inside-of-some-fields/276431
**Category:** Elasticsearch
**Created:** [June 19, 2021, 8:02am UTC](https://discuss.elastic.co/t/loading-csv-file-data-in-elasticsearch-with-explicite-double-quote-in-the-beginning-and-inside-of-some-fields/276431 "2021-06-19T08:02:32Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![dom22](https://avatars.discourse-cdn.com/v4/letter/d/5fc32e/32.png) [@dom22](https://discuss.elastic.co/u/dom22)
#### Post date: [June 19, 2021, 8:02am UTC](https://discuss.elastic.co/t/loading-csv-file-data-in-elasticsearch-with-explicite-double-quote-in-the-beginning-and-inside-of-some-fields/276431/1 "2021-06-19T08:02:32Z")

</div>

Hello,  
I'm new to Elastic search  
I have to load a csv file into Elasticsearch - csv processor looks fine for the initial purpose  
Some of the fields have the following non-regular structure:

1. Explicit Double quotes in the beginning of the field- because several values comma separated inside the field like this:  
"2017-03-30T06:00:00Z,2017-03-10T22:00:00Z,2017-03-04T10:00:00Z,2017-03-03T14:00:00Z"
2. Explicite double quotes in the middle of the field like that:  
5/16" Ring Terminal, 3 ft. 8 GA Black Ground Cable, 6 ft. Split Loom Tubing, Depth: 6.5" (165mm) (top) 11.2" (285mm), .....  
I tried to handle these cases but did not found any good solution to load all the data into the related index.  
How workaround these special cases with double quote in the beginning and in the middle of the initial CSV file ?  
Any ideas ?  
Best regards,

---

<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 17, 2021, 8:03am UTC](https://discuss.elastic.co/t/loading-csv-file-data-in-elasticsearch-with-explicite-double-quote-in-the-beginning-and-inside-of-some-fields/276431/2 "2021-07-17T08:03:00Z")

</div>

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