Avatar

Community Advisor

Hi @AsmitaSingh ,

 

I will suggest you to split you memo Data into targetData variables.

Ex: Suppose below is the value stored in your data:

<recipient>

<email>xyz@xyz.com</email>

<name>abc</name>

</recipient>

Then you can create a variable named 'email1' and assign value as:

Substring(data, Charindex(data, 'email='), 19)

Once you have value in 'email1' field try to trim your data before </email>.

 

Thanks,

Jyoti