From: ChrisH <chris.hulan@...>
Date: 2007-06-07T02:45:04+09:00
Subject: Re: Using ADO to connect to an Access database in Ruby

On Jun 5, 8:37 am, Andy Robbo <arobb...@hotmail.com> wrote:
> Right , very close to achieving my objective , thanks very much for
> everyones input so far , its really helped me along the learning curve
> with Ruby.
>
> I'm down to one last problem ...
>
> So far , I've connected to my Access database and pulled out a list of
> URLs and there ID's , i've used the URL in the code fromAlexato obtain
> the page rank.
>
> Now all I have to do is somehow parse the XML from theAlexadata back
> into Ruby to insert it back into my database...
>
> This is the XML that i'm trying to parse
>
> Response:
>
> <?xml version='1.0'?>
> <aws:UrlInfoResponse
> xmlns:aws='http://alexa.amazonaws.com/doc/2005-10-05/'><aws:Response
> xmlns:aws='http://awis.amazonaws.com/doc/2005-07-11'><aws:OperationRequest><aws:RequestId>asldkfjaslkdjfasldfj</aws:RequestId></aws:OperationRequest><aws:UrlInfoResult><aws:Alexa>
>  <aws:TrafficData>
>     <aws:DataUrl type='canonical'>rbstardynamic.co.uk/</aws:DataUrl>
>     <aws:Rank>5976859</aws:Rank>
>   </aws:TrafficData>
> </aws:Alexa></aws:UrlInfoResult><aws:ResponseStatus
> xmlns:aws='http://alexa.amazonaws.com/doc/2005-10-05/'><aws:StatusCode>Success</aws:StatusCode></aws:ResponseStatus></aws:Response></aws:UrlInfoResponse>"5"
> "essex-electrical.co.uk"
>
> I'm trying to parse the rank # (in this case "5976859")
>
> any clues ?
>
> --
> Posted viahttp://www.ruby-forum.com/.

I think the simplest way would be to store this XML in an String and
then:
start = xml.index('<aws:Rank>') + '<aws:Rank>'.length
fin = xml.index('</aws:Rank>')
rank = xml[start...fin]

Of course you could explore RegEx or an XML lib (Hpricot, ReXML,...)

Cheers
Chris