Solved

XML Query - Result returned to Excel

Posted on 2010-09-02
2
403 Views
Last Modified: 2012-06-27
I have this list of phone numbers and I need to find out if they are local to me.

Is there anyway to take this list of phone numbers and run it against this XML Query and return the <islocal>N</islocal> part to a cell in excel? My list has 144 phone numbers (NPA/NXX's).

NPA1 and NXX1 is my originating end, and NPA2, NXX2 is the terminating end:

http://localcallingguide.com/xmlrcdist.php?npa1=416&nxx1=423&npa2=212&nxx2=733

Thank you,
Brandon
  <?xml version="1.0" encoding="UTF-8" ?>

  <!DOCTYPE root (View Source for full doctype...)> 

- <root>

- <rcdist>

  <npa1>416</npa1>

  <nxx1>423</nxx1>

  <rc1>Toronto</rc1>

  <region1>ON</region1>

  <v1>4981</v1>

  <h1>2488</h1>

  <lata1>888</lata1>

  <npa2>212</npa2>

  <nxx2>733</nxx2>

  <rc2>New York City Zone 01</rc2>

  <region2>NY</region2>

  <v2>4997</v2>

  <h2>1406</h2>

  <lata2>132</lata2>

  <distance miles="342" km="550" />

  <islocal>N</islocal>

  <effdate />

  <plantype />

  <calltype />

  <monthly />

  <note />

  </rcdist>

  </root>

Open in new window

0
Comment
Question by:bccramer
2 Comments
 
LVL 11

Accepted Solution

by:
jkpieterse earned 500 total points
ID: 33594297
See this small article on how to work with XML in Excel:

http://www.jkp-ads.com/Articles/XMLAndExcel00.asp
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm Dumb-phoned(ed) Last week, I noticed this message when adding events to my Google Calendar: On June 27th (2015), Google is removing SMS as a notification option for Google Calendar events.  Their assumption is that enough people have smart p…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

867 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