Converting text to a number

API & Programming
2

To add more context: I want to sort a list of addresses by [streetname] [house number]. I’m using the Location type field.

I’m extracting the [streetname] [house number] by using this formula: Left(FullAddress(Adres), Find(FullAddress(Adres), ",") - 1) as the house number is not properly added to the addressparts (see Location field street address)

This leaves me with a list of addresses that I can sort on. However, as they are Text, the sorting creates a list like this:

Vespuccistraat 19
Vespuccistraat 1
Vespuccistraat 20

My thinking is that if I can extract the house number as a Number, I can use it to properly sort this list