I have the following text and need to extract the Supplier Name from the field. If multiple, they should be separated by a comma. Everything else can be removed.
<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><SupplierName type="System.String">HP Inc.</SupplierName><Indicator type="System.String">Purple</ClientIndicator><Selection type="System.Boolean">False</Selection></Item><Item><SupplierName type="System.String">Ricoh</SupplierName><Indicator type="System.String">Purple</Indicator ><Selection type="System.Boolean">False</Selection></Item><Item><SupplierName type="System.String">Xerox</SupplierName><Indicator type="System.String">Purple</ClientIndicator><Selection type="System.Boolean">False</Selection></Item></Items></RepeaterData>
Select all Open in new window
Any ideas?