Y
YuChieh
We have an application using SQL. In one of the field in SQL table, it's XML
coding combining multiple fields. something like this --
<?xml version="1.0" encoding="ISO-8859-15"?><ItemInfo><row addr1 = "5100
Springfield Street, Suite 210" city = "Dayton" fname = "Emily" format = ""
formattext = "" lname = "Abell" state = "OH" suffix = "" title1 = "Associate
Software Engineer" title2 = "Adroit C4ISR Center" zip = "45431" /></ItemInfo>
How do convert this whole string into separate fields in Excel?
Thanks.
coding combining multiple fields. something like this --
<?xml version="1.0" encoding="ISO-8859-15"?><ItemInfo><row addr1 = "5100
Springfield Street, Suite 210" city = "Dayton" fname = "Emily" format = ""
formattext = "" lname = "Abell" state = "OH" suffix = "" title1 = "Associate
Software Engineer" title2 = "Adroit C4ISR Center" zip = "45431" /></ItemInfo>
How do convert this whole string into separate fields in Excel?
Thanks.