Location field street address

Bugs & Issues
1

not sure if this is the intentional behavior. when i use “address” for the AddressPart function, it only returns the street name and not the numerical street address. please see below. is this intended? how would one go about extracting the numerical street address?

image
image1359×354 21.9 KB

2

I’m encountering the same issue!

{
  fullAddress: 'Cabralstraat 1, 1057 CD Amsterdam, Netherlands',
  addressParts: {
    place: 'Amsterdam',
    region: 'North Holland',
    address: 'Cabralstraat',
    country: 'Netherlands',
    locality: 'West',
    postcode: '1055 CD',
    neighborhood: 'Landlust'
  }
}

The house number isn’t in any part of the location object, Ideally it should be in the address field: “Cabralstraat 1”

3

I’ve encountered this as well.

4

Same here for Belgian adresses

5

I ran into the same issue.

This workaround did the trick for U.S. addresses:

Left(FullAddress(Address), Find(FullAddress(Address), ",") - 1)

This extracts the house number and street by capturing everything before the first comma. The -1 removes the comma from the output.

Example:

Address: 57 Smith Street, Brooklyn, New York 11201, United States

Output: 57 Smith Street

2 Likes