# DPL - multiline CSV content

**URL:** <https://community.dynatrace.com/t/dpl-multiline-csv-content/43652>\
**Category:** DQL\
**Tags:** logs, dpl\
**Created:** [January 16, 2024, 7:25pm UTC](https://community.dynatrace.com/t/dpl-multiline-csv-content/43652 "2024-01-16T19:25:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jegron](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jegron/32/12797_2.png) [@jegron](https://community.dynatrace.com/u/jegron)\
**Post date:** [January 16, 2024, 7:25pm UTC](https://community.dynatrace.com/t/dpl-multiline-csv-content/43652/1 "2024-01-16T19:25:30Z")

</div>

Hi,

I’m working on a project where I need to parse a CSV file, but I’m not sure how to effectively read and handle each line of the text. I tried this without success :

_{  
“content”: “Server1;Infrastructure\Server2;Infrastructure\Server3;Infrastructure”,  
“timestamp”: “2024-01-16T18:35:32.774000000 +0000”,  
“log.source”: “inventory”_

_}_

 ![jegron_0-1705432639202.png](https://global.discourse-cdn.com/dynatrace/original/3X/e/9/e941910a014a9e92c045d6c546fc23a652afeacd.png)

 ![jegron_1-1705432666149.png](https://global.discourse-cdn.com/dynatrace/original/3X/f/2/f2766dc2b2314f78c57a1c12930cd91d175b7dbe.png)

Thanks for your help!

Julien

---

<div class="post-metadata">

**Author:** ![Pawel\_Zalewski](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/pawel_zalewski/32/8101_2.png) [@Pawel\_Zalewski](https://community.dynatrace.com/u/Pawel_Zalewski)\
**Post date:** [January 17, 2024, 8:13am UTC](https://community.dynatrace.com/t/dpl-multiline-csv-content/43652/2 "2024-01-17T08:13:08Z")

</div>

Hi!

Did you try an array?

 ![Pawel_Zalewski_0-1705479181530.png](https://global.discourse-cdn.com/dynatrace/original/3X/7/5/759d6eb22fed5030183483f3e9b4c48c063ef493.png)

---

<div class="post-metadata">

**Author:** ![peter\_zahrer](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/peter_zahrer/32/38745_2.png) [@peter\_zahrer](https://community.dynatrace.com/u/peter_zahrer)\
**Post date:** [January 17, 2024, 9:36am UTC](https://community.dynatrace.com/t/dpl-multiline-csv-content/43652/3 "2024-01-17T09:36:48Z")

</div>

Hello,

here is a demonstartive statement:

```markup
data record(content ="""Server1;Infrastructure\Server2;Infrastructure\Server3;Infrastructure""")
| parse content, """ARRAY{(LD:host ';' LD:mode)('\\' | EOS)}{1,}:csv_arr"""
| expand csv_arr
| fieldsFlatten csv_arr
| fields host = csv_arr.host, mode = csv_arr.mode

```

---

<div class="post-metadata">

**Author:** ![jegron](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jegron/32/12797_2.png) [@jegron](https://community.dynatrace.com/u/jegron)\
**Post date:** [January 18, 2024, 10:50am UTC](https://community.dynatrace.com/t/dpl-multiline-csv-content/43652/4 "2024-01-18T10:50:25Z")

</div>

Hi,

Perfect! Thanks a lot 🙂