Split XML format and get the exact value from the string


Below attached is the string I’m getting from XML file and I want to fetch only https://google.com from that string, I tried Split but not working, can anyone please help me here, Thanks in advance!

Sample String.txt (1.2 KB)

can you share your xml file instead of string file

Tag is Body, That value is what i shared in txt file above, I can’t share xml file since it is confidential data

“body”: “<table border=“0” cellspacing=“0” cellpadding=“0” width=“100%”><td align=“center” style=“padding-top:30px;”>\n

\n<table cellspacing=“0” cellpadding=“0”><td align=“center” height=“44” style=“font-size:15px;color:#333;background-color:#ffc820;font-family:Helvetica, Arial, ‘Sans Serif’;font-weight:bold;text-align:center;text-decoration:none;”><a href=*"https:google.com*” style=“font-size:15px;color:#333;background-color:#ffc820;font-family:Helvetica, Arial, ‘Sans Serif’;font-weight:bold;text-align:center;text-decoration:none;”><span style=“padding:0px 24px;line-height:44px;”> REVIEW DOCUMENTS \n
\n\n\n\n<td style=“padding:0px 24px 24px 24px;color:#000;font-size:16px;font-family:Helvetica, Arial, ‘Sans Serif’;background-color:#FFF;”>\n<table border=“0” cellspacing=“0” cellpadding=“0”><td style=“padding-bottom:20px;”>\n<div style=“font-family:Helvetica, Arial, ‘Sans Serif’;font-weight:bold;line-height:18px;font-size:15px;color:#333;”>Saaa\n<div style=“font-family:Helvetica, Arial, ‘Sans Serif’;line-height:18px;font-size:15px;color:#666;”>a@gmail\n\n"

Ok i will develop a workflow with dummy xml and modify the xml as per document

Hi @ramesh_kola

please find the attached overall project file
Json usecase.zip (5.1 KB)
Hope its solves your issue
kindly update me whether you got solution or not

Robin S