How do I get the last values of a string using the parse command?

badgerfifteen — Wed, 18 Feb 2026 11:47:23 GMT

Hi,

I'm having trouble understanding the DPL documentation. What I want to do is extract the last characters after a certain character, in this case it would be '/'. I am trying to extract just the filename from the string. For example,

I would just want input.csv from the following filepath/string:

/NODEA12XY/data/services/svc_rt/module/xxabc/3.4.7/in/input.csv

Re: How do I get the last values of a string using the parse command?

dannemca — Wed, 18 Feb 2026 12:57:14 GMT

Hi @badgerfifteen

You can achieve this with the "substring" and "lastindexof" function, https://docs.dynatrace.com/docs/platform/grail/dynatrace-query-language/functions/string-functions#substring , https://docs.dynatrace.com/docs/platform/grail/dynatrace-query-language/functions/string-functions#lastIndexOf

data record(content = "/NODEA12XY/data/services/svc_rt/module/xxabc/3.4.7/in/input.csv"), record(content = "/NODEA12XY/data/services/input2.csv"), record(content = "/NODEA12XY/input3.csv") | fieldsAdd FileName = substring(content, from:lastIndexOf(content, "/") + 1)

Try and let us know.

topic How do I get the last values of a string using the parse command? in DQL

How do I get the last values of a string using the parse command?

Re: How do I get the last values of a string using the parse command?