Split XML format and get the exact value from the string

Help Studio
, ,
1

Hello,

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)

2

can you share your xml file instead of string file

3

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"

4

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

5

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

Thanks,
Robin S