topic Re: Parse file directory in DQL

Parse File Directory Paths Using DQL for Structured Data

Nicolas_M — Thu, 18 Dec 2025 10:55:54 GMT

Hello the community,

I'm ingesting a log file in this format, and I want to parse the information in color to make it easier to read in reports :

P:\LOGS\services\NameApps\NameApps.Light\NameApps.Light.HUBLOT.log

Could you help me ?

Nicolas

Re: Parse file directory

marco_irmer — Wed, 23 Apr 2025 22:12:12 GMT

Hi there. When you say 'reports', what exactly do you mean? Are you talking about having data on a Dashboard/Notebook, or executing DQL inside a workflow that perhaps would deliver data via email?

Re: Parse file directory

Nicolas_M — Thu, 24 Apr 2025 08:57:30 GMT

Hi,

In a dashboard, where I execute DQL to show information,

Re: Parse file directory

marco_irmer — Thu, 24 Apr 2025 13:29:48 GMT

To the best of my knowledge, Dynatrace Dashboards do not currently provide a way to format text color unless thresholds are used, which may not be feasible for what you are trying to do.

The closest thing I can recommend is to make use of the Markdown functionality using a custom "Markdown" column in a table. This would also require manipulating the path value in DQL so that it includes the markdown syntax.

One other possible alternative would be to manipulate value itself based on what's relevant to your users. For instance, you might replace non-important parts of the path with wildcard or placeholder characters..

In any case, I hope this helps!

Re: Parse file directory

Nicolas_M — Thu, 24 Apr 2025 13:35:06 GMT

Sorry, the question is not about how to add color at the text,

but how to split the log.source name to have example blue or green part of le filename in my dashboard

P:\LOGS\services\NameApps\NameApps.Light\NameApps.Light.HUBLOT.log

Re: Parse file directory

marco_irmer — Thu, 24 Apr 2025 17:07:34 GMT

My mistake, sorry. For this you would use the DQL parse command to extract the relevant parts of the log path into new field values. The parse command works with the Dynatrace Pattern Language (DPL). You'll want to review the DPL documentation in order to craft the pattern that will fit your needs. There's also a DPL Architect function available in Dynatrace that can help with this.