kwarden13
asked on
VBA to Cleanup Excel Field
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.
Any ideas?
<?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>
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Appears to answer the question