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.

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.

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#:

Code:

foreach (object o in results) {
  Location loc = o as Location;
  if (loc == null)
    continue;
  // hier it is a Location

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

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.