Need to extract specific tag from XML

[Deeipauk (Deeipauk RS)]

Hi,

Need to extract data from a specific tag in XML output, please share your ideas…
Find below pic highlighted

Thanks

[loginerror (Maciej Kuźmicz)]

Hi @Deeipauk

This should return the value:

System.Text.RegularExpressions.Regex.Match(yourVariable,"(?<=\<AuthenticateUserResult\>).+(?=\<\/AuthenticateUserResult\>)").ToString

See here for more info.

[Deeipauk (Deeipauk RS)]

@loginerror

System.Text.RegularExpressions.Regex.Match(yourVariable,“(?<=&lt;AuthenticateUserResult&gt;).+(?=&lt;/AuthenticateUserResult&gt;)”).ToString

Thanks…This needs to be kept in Assign activity?

[loginerror (Maciej Kuźmicz)]

That is correct, assign this to your output variable.

[Deeipauk (Deeipauk RS)]

Yes its working, Thanks…

Just to add a point – yourVariable should be a string variable

[Deeipauk (Deeipauk RS)]

I felt this regular expression can help me to find solution in another level. After extracting this information I need to place it in another XML tag… below is the source XML and where I need to replace this extracted value, if you have any suggestions will help me move ahead.

[loginerror (Maciej Kuźmicz)]

It is possible
This one will do it:

System.Text.RegularExpressions.Regex.Replace(finalString,"(?<=\<urn:AuthenticationToken\>).+(?=\<\/urn:AuthenticationToken\>)","newValue") 

See this project for ease of reference:
RegexSolution.zip (2.2 KB)

[Deeipauk (Deeipauk RS)]

Thats great its working fine…

Thanks for your help