How do i parse xml in i would like to get colounm and the value from the xml

Posted on 2011-10-30
Last Modified: 2012-06-21
How do i parse xml in i would like to get colounm and the value from the xml so for example I want the  <p231:status>Delivered</p231:status> The colounm name which is status which is represented with one veriable and the value which is Delivered that would assign to a different veriable.
here is the xml :

- <soapenv:Envelope xmlns:soapenv="" xmlns:soapenc="" xmlns:xsd="" xmlns:xsi="">
  <soapenv:Header />
- <soapenv:Body>
- <p231:getTraceDataResponse xmlns:p231="">
- <p231:getTraceDataReturn>
  <p231:appointment />
  <p231:trailer />
  <p231:signature />
  <p231:origAddress>3915 WEST MORRIS STREET</p231:origAddress>
  <p231:origName>INDIANAPOLIS, IN</p231:origName>
  <p231:origPhone>(800) 450-6335</p231:origPhone>
  <p231:origFax>(317) 481-8200</p231:origFax>
  <p231:destAddress>80 INDUSTRIAL DRIVE</p231:destAddress>
  <p231:destName>PROVIDENCE, RI</p231:destName>
  <p231:destPhone>(800) 847-4611</p231:destPhone>
  <p231:destFax>(401) 334-9905</p231:destFax>
  <p231:url />
  <p231:scac />
  <p231:errorMessage />
Question by:1030071002
    LVL 10

    Accepted Solution


    Author Comment

    can I get some scripts to start with I cant figure out how this work I have a wsdl file

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    It’s quite interesting for me as I worked with Excel using for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
    Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now