topic Re: How to replace multiple strings in the same Expression/field using replaceString function in DQL

How to replace multiple strings in the same Expression/field using replaceString function

Kaladhar — Tue, 13 May 2025 10:48:39 GMT

Hi Team,

I have this requirement to replace multiple strings in an expression which is having two different substrings.

For the Example below:

Category field has two results either A or B and I want to replace 'A' with 'XML' and 'B' with 'TEXT'.

I have used below command with replaceString and it worked for 'A'.

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

How do I replace the another string B in the same Category field(without adding new fieldsAdd command.)

Thanks,

Re: How to replace multiple strings in the same Expression/field using replaceString function

krzysztof_hoja — Tue, 13 May 2025 20:28:52 GMT

if "Category field has two results either A or B" why do you need replaceString, not just if?

If my understanding of assumption is correct, this could look like this:

data record(Category="A"), record(Category="B") | fieldsAdd Category = coalesce( if(Category=="A","XML"), if(Category=="B","TEXT"))

Re: How to replace multiple strings in the same Expression/field using replaceString function

MuhammadGamal — Tue, 13 May 2025 21:08:26 GMT

Can you try this :
| fieldsAdd CategoryReplaced = replaceString(replaceString(Category, "A", "XML"), "B", "TEXT")
please check the simple Example :

Re: How to replace multiple strings in the same Expression/field using replaceString function

Kaladhar — Wed, 14 May 2025 08:46:15 GMT

This works too. Thank you for the response.

I was looking to get my hands on 'string functions' by dynatrace also more results might be added in the future.