https://community.dynatrace.com/t5/DQL/Data-from-csv-including-comma/m-p/299453#M3340 <P>Data is currently in a string from a csv for example</P><P>2026-05-13 22:51:49.585,email@email.com,service,com.corp.ag,DENIED,,"designer, app-user"</P><P>Need to parse it so the data is in format:</P><P>| timestamp&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | user_email&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | service | domain&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| access&nbsp; &nbsp; | field1 | roles&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp;</P><P>| 2026-05-13 22:51:49.585 | <A href="mailto:example_email@email.com" target="_blank" rel="noopener">email@email.com</A>&nbsp;| service | com.corp.ag&nbsp; | DENIED |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | designer, app-user |&nbsp;</P><P>The issue being the final field is encapsulated within double quotations and has a comma, and there is a field1 value that is null. Using DPL it doesn't like the blank field, and using splitString(data, ",") splits most of the data correctly but incorrectly the final field which is meant to stay together.&nbsp;</P> Thu, 14 May 2026 00:24:50 GMT loopy 2026-05-14T00:24:50Z https://community.dynatrace.com/t5/DQL/Data-from-csv-including-comma/m-p/299453#M3340 <P>Data is currently in a string from a csv for example</P><P>2026-05-13 22:51:49.585,email@email.com,service,com.corp.ag,DENIED,,"designer, app-user"</P><P>Need to parse it so the data is in format:</P><P>| timestamp&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | user_email&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | service | domain&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| access&nbsp; &nbsp; | field1 | roles&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp;</P><P>| 2026-05-13 22:51:49.585 | <A href="mailto:example_email@email.com" target="_blank" rel="noopener">email@email.com</A>&nbsp;| service | com.corp.ag&nbsp; | DENIED |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | designer, app-user |&nbsp;</P><P>The issue being the final field is encapsulated within double quotations and has a comma, and there is a field1 value that is null. Using DPL it doesn't like the blank field, and using splitString(data, ",") splits most of the data correctly but incorrectly the final field which is meant to stay together.&nbsp;</P> Thu, 14 May 2026 00:24:50 GMT https://community.dynatrace.com/t5/DQL/Data-from-csv-including-comma/m-p/299453#M3340 loopy 2026-05-14T00:24:50Z https://community.dynatrace.com/t5/DQL/Data-from-csv-including-comma/m-p/299465#M3341 <P>You can handle both cases using the appropriate DPL matchers: `LD*` for the optional/empty `field1` value, and `CSVDQS` for the quoted CSV string in `roles`, since it contains a comma and should remain as one field.<BR />If the CSV value is enclosed in single quotes instead of double quotes, then `CSVSQS` can be used instead.</P> Thu, 14 May 2026 10:15:33 GMT https://community.dynatrace.com/t5/DQL/Data-from-csv-including-comma/m-p/299465#M3341 Mohamed_Hamdy 2026-05-14T10:15:33Z