Search code examples
c#xmlxelement

Getting address data from Google Maps XML

I've extracted some addresses from google maps and they are in an xml file. In myxml file I have some xelements like 

<location>, <place_id>, <adr_address>, etc

The 'adr_address' element has different classes and each class contains, city, street, country, etc. values. How do I get each value from the 'adr_address' xElement

<adr_address>&lt;span class="street-address"&gt;1805 Geary Boulevard&lt;/span&gt;, &lt;span class="locality"&gt;San Francisco&lt;/span&gt;, &lt;span class="region"&gt;CA&lt;/span&gt; &lt;span class="postal-code"&gt;94115&lt;/span&gt;, &lt;span class="country-name"&gt;United States&lt;/span&gt;</adr_address>

I'm putting the adr_address xElement in to a object here, but not sure what to do to get the values of each class after that.

XElement firstOrDefault = xElement.Descendants("adr_address").FirstOrDefault();
Solution

  • It seems strange to me that you get values like address, zip code, .. in this form. Normally Google Maps should give these values properly parsed.

    Anyway, what you can do is unescape the special characters like this:

    firstOrDefault.Value.Replace("&lt;", "<").Replace("&gt;", ">");

    and then use this regular expression to extract the values:

     var str = "&lt;span class=\"street-address\"&gt;1805 Geary Boulevard&lt;/span&gt;, &lt;span class=\"locality\"&gt;San Francisco&lt;/span&gt;, &lt;span class=\"region\"&gt;CA&lt;/span&gt; &lt;span class=\"postal-code\"&gt;94115&lt;/span&gt;, &lt;span class=\"country-name\"&gt;United States&lt;/span&gt;".Replace("&lt;", "<").Replace("&gt;", ">");

        Regex regex = new Regex("<span class=\"street-address\">(.*)</span>, <span class=\"locality\">(.*)</span>, <span class=\"region\">(.*)</span> <span class=\"postal-code\">(.*)</span>, <span class=\"country-name\">(.*)</span>");
        Match match = regex.Match(str);

        if (match.Success)
        {
            string address = match.Groups[1].Value;
            string locality = match.Groups[2].Value;
            string region = match.Groups[3].Value;
            string zip = match.Groups[4].Value;
            string country = match.Groups[5].Value;
         }