how to use substring in PropertyTransfer

Question

I want to transfer one attribute value from 1 request to another request.i have used PropertyTransfer step to do the same.but the actual value is present in the description format (highlighted in bold below).and 2nd request will have below full string.e.g.Attribute 'Party ID' is transformed from ('') to ('49025')&nbsp;I just need to transfer the value i.e. 49025&nbsp;so what step should i use to do a substring?&nbsp;request1 response:&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &lt;Transaction&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Response type="Add"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;MasterCatalogRecord etype="Entity" commandqualifier="Validate/NoProcess"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ExternalKeys&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Key name="MASTERCATALOGNAME"&gt;PARTY_2&lt;/Key&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ExternalKeys&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;EntityData&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="PartyType" type="string"&gt;Individual&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="NamePrefix" type="string"&gt;Mr.&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="FirstName" type="string"&gt;Hemali&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="LastName" type="date"&gt;Shinde&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="NameSuffix" type="string"&gt;Sr.&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Attribute name="Gender" type="string"&gt;Female&lt;/Attribute&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/EntityData&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ResultList highestSeverity="Info" reference="PartyName"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Result severity="Info" code="GEN-7300"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Description lang="en"&gt;Attribute 'Party Name' is transformed from ('') to ('Mr. Hemali Shinde Sr.')&lt;/Description&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/Result&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ResultList&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ResultList highestSeverity="Info" reference="RELATIONSHIP_LIST"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Result severity="Info" code="GEN-7300"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Description lang="en"&gt;attribute RELATIONSHIP_LIST assigned value = [Contact_Details, Associated_Organisation]&lt;/Description&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/Result&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ResultList&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ResultList highestSeverity="Info" reference="PRODUCTID"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Result severity="Info" code="GEN-7300"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Description lang="en"&gt;Attribute 'Party ID' is transformed from ('') to ('49025')&lt;/Description&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/Result&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ResultList&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/MasterCatalogRecord&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;ResultList highestSeverity="Info" reference="Add"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Result severity="Info" code="SVC-11025"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;Description lang="en"&gt;Service 'Validate/NoProcess' executed successfully.&lt;/Description&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/Result&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/ResultList&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/Response&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;TransactionResult result="Completed"&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;SuccessCount&gt;1&lt;/SuccessCount&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;EventID&gt;40041&lt;/EventID&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/TransactionResult&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/Transaction&gt;&nbsp; &nbsp; &nbsp; &lt;/DataService&gt;&nbsp; &lt;/soapenv:Body&gt;&lt;/soapenv:Envelope&gt;&nbsp;&nbsp;Request 2 Request: ( it should have only that ID )&nbsp;&nbsp;&nbsp;&lt;Identity&gt;&nbsp;&nbsp;&nbsp; &lt;DirectoryPath&gt;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;Directory type="Enterprise"&gt;&lt;/Directory&gt;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &lt;Directory type="User"&gt;&lt;/Directory&gt;&nbsp;&nbsp;&nbsp; &lt;/DirectoryPath&gt;&nbsp;&nbsp;&nbsp; &lt;Authentication type="Password"&gt;&lt;/Authentication&gt;&lt;/Identity&gt;&lt;Transaction&gt;&lt;Command type="Delete"&gt;&lt;MasterCatalogRecord commandqualifier="Record" etype="Entity"&gt;&lt;ExternalKeys&gt;&nbsp;&nbsp;&nbsp; &lt;Key name="MASTERCATALOGNAME"&gt;PARTY_2&lt;/Key&gt;&nbsp;&nbsp;&nbsp; &lt;Key name="PRODUCTID" type="String"&gt;Attribute 'Party ID' is transformed from ('') to ('49026')&lt;/Key&gt;&lt;/ExternalKeys&gt;&nbsp;&lt;/MasterCatalogRecord&gt;&nbsp;&lt;/Command&gt;&nbsp;&lt;/Transaction&gt;&nbsp;&lt;/DataService&gt;&nbsp;&lt;/soapenv:Body&gt;&nbsp;&lt;/soapenv:Envelope&gt;&nbsp;Kindly help.&nbsp;Thanks,kanchan

himanshutayal · Answer

Hi&nbsp;kanchanpatil,
&nbsp;
Write&nbsp;below&nbsp;line of code in your Source box of Property Transfer
&nbsp;
str = str.split("\)")[1].replace("(","").replace("'","")
&nbsp;
replace str to the variable of yours
&nbsp;
Do Like and Accept if you Find it as Solution.
&nbsp;
Thanks,
Himanshu Tayal

Forum Discussion

how to use substring in PropertyTransfer

Related Content

Substring not working

Search for a substring using wildcards

Insert Prefix to a Groovy Generated Substring value?

Selecting items by substring in tree view

Python code to return a substring using regular expressions?

Recent Discussions

Accessing database connection string from groovy test step

Assert Step Not Executing All Assertions

Include external files (XML) for JDBC connection

JDBC database connection pooling

JDBC "Some connection settings are not specified"