topic Re: How to add a second condition when using replaceString() function? in DQL

How to add a second condition when using replaceString() function?

badgerfifteen — Thu, 05 Sep 2024 11:53:06 GMT

Hi I am currently using the replaceString() function to replace some values in a DQL query. How do I specify a second piece of text to be filtered?

Re: How to add a second condition when using replaceString() function?

p_devulapalli — Fri, 06 Sep 2024 01:57:32 GMT

There is an example in the docs , is this what you are after ?

https://docs.dynatrace.com/docs/shortlink/string-functions#replaceString

data record(content = "DQL is awesome!"), record(content = "Dynatrace Query Language"), record(content = "abcabca") | fieldsAdd replaceString(content, "awesome", "simple"), replaceString(content, "abca", "xyz")

Re: How to add a second condition when using replaceString() function?

Kaladhar — Tue, 13 May 2025 10:40:31 GMT

Did you figure out the solution for this ??

I have the similar requirement with the expression(where substrings should be replaced) is having two different substrings.

For Ex: Category field has two results either A or B and I want to replace 'A' with 'XML' and 'B' with 'TEXT'. I used below command and it worked for A. How do I replace the the another string B in the same Category field(without adding new fieldsAdd command.)

fieldsAdd replaceString(Category, "A", "XML")

Thanks,