Parsing HTML returned from CFHTTP

Report · Dec 19, 2008

I am trying to create a function that will parse out individual pieces of information returned by a cfhttp request. I need the name of the city, country, and state returned. I need the script to start at the word " CITY: ", " STATE: ", and " COUNTRY: " respectively and ends at . I know I can use findNoCase to locate the start point, but how can I say 'get until you reach the next ' ?

Here is my returned data (I bolded what I need returned):
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML//EN"> <HTML><HEAD><TITLE>Geo Results</TITLE> </HEAD><BODY> VERSION=1.0 TARGET: 172.20.85.84 NAME: IANA-BBLK-RESERVED1 NUMBER: 172.16.0.0 - 172.31.255.255 CITY: AMSTERDAM STATE: NORTH HOLLAND (province) COUNTRY: NL LAT: 52.35 LONG: 4.90 LAT_LONG_GRAN: City LAST_UPDATED: NIC: RIPE LOOKUP_TYPE: Block Allocation RATING: DOMAIN_GUESS: ripe.net STATUS: OK </BODY></HTML>

Report · Dec 19, 2008

This would probably be betters served by reFindNoCase() rather then the
simplier findNoCase(). The former allows you to use regular expressions
to find more complex strings. Something like
"refindnocase("CITY:.*[^<] ",cfhttp.FileContent)" should be close to
what you are looking for, but I am not supper efficient at regular
expression code and this is untested and untried.

Report · Dec 20, 2008

Seems like its on the right path, but I get: 242

Report · Dec 21, 2008

Seems like its on the right path, but I get: 242

The position in the string.

Report · Dec 21, 2008

You can do it in Coldfusion 8 using the reMatch or reMatchNoCase function, as follows:

Report · Dec 21, 2008

That would be awesome. I am sorry, I should have mentioned that I am working on Blue Dragon at the U. That code will come in handy on another project though!

Report · Dec 21, 2008

I am working on Blue Dragon at the U.

Never mind. Nobody's perfect.;)
The following should do.