Link to home
Start Free TrialLog in
Avatar of 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.

<?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>

Open in new window

Any ideas?
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Appears to answer the question