MapForums

I have a problem parsing out some addresses that Mappoint returns for lat/on locations.

When I try to parse out street and city for some returned address that are actually not street addresses I get an error.

The one that snags the most is an address something like "San Francisco Airport", for a lat/lon around the terminal.

Is there a way to detect such a non-parsable location such as the one above and then I would display the full address with city zip etc, but otherwise just glean and display the street and city?

Hi,

You have to check for null values on each object before parsing it.

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
MapPoint coding demo
Order MapPoint 2009 with Routing and User Tools Spreadsheet

I tried something like using the isnull function.

But as soon as I declare the street item that i want to check if it is null, the error code says that the item does not exist.

Thanks for the input, by the way.

Then you also have to check the object where the street belongs to to see if it is not null. eg, you have a collection, you have to check for each item you wants to check if it is not null, if it is a location, if the StreedAddress in the Location is not null. And then you can access Street, Value, etc.

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
MapPoint coding demo
Order MapPoint 2009 with Routing and User Tools Spreadsheet

Wilfiied;

I get the Street Addresses from lat/lon queries. Most of the StreetAddress results parse just fine. But some of the StreetAddress's returned by Mappoint are not exactly street addresses, such at the San Francisco Airport example.

When I try to parse such a response, I get an error that the street component has not been declared, I cannot just test it for being null.

I'm stumped

Hi,

You also have to check the object type of the collection. For example in your case you want a Location object, but the results could have also other objects witch dont have the StreetAddress property. So you cannot check for its null value if the property does not exists.

For example in c#:

It s from the top of my head, so there may be typo's.

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
MapPoint coding demo
Order MapPoint 2009 with Routing and User Tools Spreadsheet

I looked at the address, and it is separated by commas. Sort of a comma deliminated string.

I only want the street and city fields, the first 2.

So I used VBA to detect the commas, and I stripped out the fields that I needed.

Thanks

Hi,

Streetaddress has precides the Value property also a Street and a City property. You can yous them instead of parsing trough the Value I think.

__________________
rgds, Wilfried Mestdagh
www.mestdagh.biz
MapPoint coding demo
Order MapPoint 2009 with Routing and User Tools Spreadsheet