topic Re: Regex to read xml data dynamic in Dashboards & Visualizations

Regex to read xml data dynamic

keeplearningbud — Fri, 05 May 2017 22:02:28 GMT

Hi..

I am trying to create a dashboard which extracts errorCode field from multiple xmls. Xpath for it would be different for different outputs. For ex: for createUser it is abc and for deleteUser it would be xyz. I need to have the xpath dynamic which extracts errorCode alone. I am trying with below regular expression which I know makes no sense. Please help.

Re: Regex to read xml data dynamic

gcusello — Sat, 06 May 2017 08:58:28 GMT

hi keeplearningbuddy,
using this regex you can take all erroCodes and test it at https://regex101.com/r/9oqQxH/1

\<errorCode>(?<errorCode>[^\<]*)\<\/errorCode>

if instead you like to determine errorCode related to createUser, you can use this regex and test it at https://regex101.com/r/AhlTiY/1

\<createUser\>[^\<]*\<errorCode>(?<errorCode>[^\<]*)\<\/errorCode>

Bye.
Giuseppe

Re: Regex to read xml data dynamic

keeplearningbud — Mon, 08 May 2017 15:17:28 GMT

Thanks Giuseppe. This worked 🙂