Parse file directory

[Nicolas_M]

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

[marco_irmer]

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?

[Nicolas_M]

Hi,

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

[marco_irmer]

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.

[marco_irmer]

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!

[Nicolas_M]

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