DQL Parsing on logs

[jordanb]

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""

[sinisa_zubic · Accepted solution]

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