topic Re: How to RegEx a user action property? in Open Q&A

How to RegEx a user action property?

mareguera — Mon, 27 Mar 2023 14:19:13 GMT

I have created a user action property to get the revenue using a CCS selector.

I get the following data:

[, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , Total: $500,00]

It see that is possible to "Apply cleanup rule" based on regex.

Please, does someone help me to create the proper regex to get only the figure 500,00?

Thank you

radek_jasinski — Mon, 27 Mar 2023 13:55:04 GMT

Hi,

You can use [\d,]+\,\d+

Regards,

Radek

mareguera — Mon, 27 Mar 2023 15:11:54 GMT

Than you. Is there any limitation in Dynatrace related to Regex?

If I use () I get the following:

Thank you.

AntonPineiro — Mon, 27 Mar 2023 17:17:07 GMT

Hi,

Yes, Dynatrace has limitations, I was asking today if Dynatrace has a tool for scenarios as yours: Dynatrace Regex Tester

This should work "(\d{1,10},\d{0,2})" but I think this can be improved:

Best regards

mareguera — Mon, 27 Mar 2023 17:31:51 GMT

Thank you. It works properly.