topic DQL Parsing on logs in DQL

DQL Parsing on logs

jordanb — Wed, 05 Jul 2023 21:21:00 GMT

We are currently trying to use the parse feature in DQL to parse out paths that end in different integers. The current format is V + an integer. How can we make it so we do not have to hardcode every possible version such as v9/start/order or v8/start/order/ In its current form, it only works for v10. Thanks!

We are using "| parse RequestedPath, "DATA 'v10' LD:path2""

Re: DQL Parsing on logs

sinisa_zubic — Wed, 05 Jul 2023 21:31:55 GMT

Hi @jordanb

You can use DPL macros to achieve this.

This DPL should work for your use case

| parse RequestPath, """$version = 'v' int; LD $version LD:path """

Please have a look at pattern expression macros for further details: https://www.dynatrace.com/support/help/shortlink/dpl-pattern-expression-macros

Best,
Sini