Hello I am tried to extract an XML value from the below XML data using Regex

Help Studio
, ,
1

Hello I am tried to extract an XML value from the below XML data using Regex, I have used Regex builder and wrote expression “<TRANS_NO>(.*?)</TRANS_NO>” which returns full tag instead of only the the value ‘22170’. Please help me

image
image947×528 70.1 KB

2

Hi @allen3736

(?<=\<TRANS_NO\>)(.*?)(?=\</TRANS_NO\>)
1 Like
3

HI @allen3736

Please check the below screenshot:

(?<=\<TRANS_NO\>)(.*?)(?=\</TRANS_NO\>)

image
image1085×528 12.7 KB

Regards

4

@allen3736

For xml you can deserialize and access the info easily…instead of using regex and all…please check this

Cheers

1 Like
5

@vrdabberu Thank you for quick response with solution. I can now get the value alone

6

Hi @allen3736

If you find the solution for your query please do mark as solution to close the loop.

Thank You.

Regards

7

Thanks for the solution closing the thread.

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.