https://community.dynatrace.com/t5/DQL/Extract-data/m-p/279976#M2227 <P>Your field value appears to be URL encoded. I ran it through the <A href="https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-query-language/functions/string-functions#decodeUrl" target="_self">decodeURL()</A> function and discovered that it appears to be JSON format (although your snippet is not complete).</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="marco_irmer_0-1750693870805.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/28625i3D193AF1EFE44E10/image-size/medium?v=v2&amp;px=400" role="button" title="marco_irmer_0-1750693870805.png" alt="marco_irmer_0-1750693870805.png" /></span></P><P>If it's a fully formed JSON, then you might be able to use the DPL <A href="https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-pattern-language/log-processing-json-object" target="_self">parser for JSON</A> after the decodeURL() function.</P> Mon, 23 Jun 2025 15:52:58 GMT marco_irmer 2025-06-23T15:52:58Z https://community.dynatrace.com/t5/DQL/Extract-data/m-p/279888#M2226 <P>Hello i have this text, someone could help me to extract data from this column:&nbsp;datos=%7B%22fecha%22%3A%2220250620110916%22%2C%22fechaFinal%22%3A%2220250620%22%2C%22data%22%3A%22056%22%2C%22secuencia%22%3A%22150222%22%2C%22 try to use parse like this&nbsp;LD "%22%3A%22" ld :fecha ld "%22%2C%22 but dont show me data</P> Fri, 20 Jun 2025 19:17:35 GMT https://community.dynatrace.com/t5/DQL/Extract-data/m-p/279888#M2226 marusla 2025-06-20T19:17:35Z https://community.dynatrace.com/t5/DQL/Extract-data/m-p/279976#M2227 <P>Your field value appears to be URL encoded. I ran it through the <A href="https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-query-language/functions/string-functions#decodeUrl" target="_self">decodeURL()</A> function and discovered that it appears to be JSON format (although your snippet is not complete).</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="marco_irmer_0-1750693870805.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/28625i3D193AF1EFE44E10/image-size/medium?v=v2&amp;px=400" role="button" title="marco_irmer_0-1750693870805.png" alt="marco_irmer_0-1750693870805.png" /></span></P><P>If it's a fully formed JSON, then you might be able to use the DPL <A href="https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-pattern-language/log-processing-json-object" target="_self">parser for JSON</A> after the decodeURL() function.</P> Mon, 23 Jun 2025 15:52:58 GMT https://community.dynatrace.com/t5/DQL/Extract-data/m-p/279976#M2227 marco_irmer 2025-06-23T15:52:58Z https://community.dynatrace.com/t5/DQL/Extract-data/m-p/279977#M2228 <P>Thank you!!!!</P> Mon, 23 Jun 2025 15:57:05 GMT https://community.dynatrace.com/t5/DQL/Extract-data/m-p/279977#M2228 marusla 2025-06-23T15:57:05Z