# Split a csv fied into nested array

**URL:** <https://discuss.elastic.co/t/split-a-csv-fied-into-nested-array/143893>\
**Category:** Logstash\
**Created:** [August 10, 2018, 3:33pm UTC](https://discuss.elastic.co/t/split-a-csv-fied-into-nested-array/143893 "2018-08-10T15:33:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Orange](https://avatars.discourse-cdn.com/v4/letter/o/65b543/32.png) [@Orange](https://discuss.elastic.co/u/Orange)\
**Post date:** [August 10, 2018, 3:33pm UTC](https://discuss.elastic.co/t/split-a-csv-fied-into-nested-array/143893/1 "2018-08-10T15:33:42Z")

</div>

hello,I use logstash to import csv to elasticsearch, my question is that one of the fields contains the string formatted as [{"level1":aa,"level2":bb},{"level1":aaa,"level2",bbb},...],The field, is array.and i need to parse this and put into elasticsearch like this eg:  
levels:[  
{ "level1":"aa",  
"level2":"bb"  
},  
{ "level1":"aaa",  
"level2":"bbb"  
}]  
. what are possible solutions for this?Thank you!

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [August 10, 2018, 4:13pm UTC](https://discuss.elastic.co/t/split-a-csv-fied-into-nested-array/143893/2 "2018-08-10T16:13:22Z")

</div>

> [@Orange](#):
>
> [{"level1":aa,"level2":bb},{"level1":aaa,"level2",bbb},...]

Provided the string is valid JSON (e.g. all the string values are in double quotes) a simple JSON filter will parse that

```
json { source => "someColumn" target => "someField" }

```

---

<div class="post-metadata">

**Author:** ![Orange](https://avatars.discourse-cdn.com/v4/letter/o/65b543/32.png) [@Orange](https://discuss.elastic.co/u/Orange)\
**Post date:** [August 11, 2018, 2:13am UTC](https://discuss.elastic.co/t/split-a-csv-fied-into-nested-array/143893/3 "2018-08-11T02:13:39Z")

</div>

Ok,I will try it,thank you!

---

<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 8, 2018, 2:13am UTC](https://discuss.elastic.co/t/split-a-csv-fied-into-nested-array/143893/4 "2018-09-08T02:13:46Z")

</div>

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