# Location field street address

**URL:** <https://community.fibery.io/t/location-field-street-address/4477>\
**Category:** Bugs & Issues\
**Created:** [May 20, 2023, 12:57pm UTC](https://community.fibery.io/t/location-field-street-address/4477 "2023-05-20T12:57:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![T\_A](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/t_a/32/1619_2.png) [@T\_A](https://community.fibery.io/u/T_A)\
**Post date:** [May 20, 2023, 12:57pm UTC](https://community.fibery.io/t/location-field-street-address/4477/1 "2023-05-20T12:57:11Z")

</div>

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](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/b/b19d8021daa8bfa371b996c7662028a6067ea94c.png)

---

<div class="post-metadata">

**Author:** ![tomvb](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/tomvb/32/8764_2.png) [@tomvb](https://community.fibery.io/u/tomvb)\
**Post date:** [May 5, 2024, 6:58pm UTC](https://community.fibery.io/t/location-field-street-address/4477/2 "2024-05-05T18:58:36Z")

</div>

I’m encountering the same issue!

```auto
{
  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”

---

<div class="post-metadata">

**Author:** ![cssrctech](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/cssrctech/32/5154_2.png) [@cssrctech](https://community.fibery.io/u/cssrctech)\
**Post date:** [May 7, 2024, 8:31pm UTC](https://community.fibery.io/t/location-field-street-address/4477/3 "2024-05-07T20:31:19Z")

</div>

I’ve encountered this as well.

---

<div class="post-metadata">

**Author:** ![StevenSkillit](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/stevenskillit/32/6084_2.png) [@StevenSkillit](https://community.fibery.io/u/StevenSkillit)\
**Post date:** [January 22, 2025, 10:25am UTC](https://community.fibery.io/t/location-field-street-address/4477/4 "2025-01-22T10:25:59Z")

</div>

Same here for Belgian adresses

---

<div class="post-metadata">

**Author:** ![Edan](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/edan/32/11187_2.png) [@Edan](https://community.fibery.io/u/Edan)\
**Post date:** [March 15, 2025, 3:56am UTC](https://community.fibery.io/t/location-field-street-address/4477/5 "2025-03-15T03:56:03Z")

</div>

I ran into the same issue.

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

```auto
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`