Any ideas how to break out EU addresses into street & house number?

[peskywinnets]

I have a working solution for UK/US addresess, which typically follow this format

123 Station Road

but Germans Italians & Spanish etc reverse things, for example...

Via Trieste 22

...any ideas how I can break out the above to

22 (Property number)
Via Trieste (Street Name)

So, I need to start from the right of the string & locate the first space etc...but it's beyond me!

Many thanks!

 

[jdraw]

Hi Pesky,
How about giving us some sample data?
Also, what is the business rule(s) involved?

I country in this list, then "process" the address???

The EU countries are: Austria, Belgium, Bulgaria, Croatia, Republic of Cyprus, Czech Republic, Denmark, Estonia, Finland, France, Germany, Greece, Hungary, Ireland, Italy, Latvia, Lithuania, Luxembourg, Malta, Netherlands, Poland, Portugal, Romania, Slovakia, Slovenia, Spain and Sweden.

I did some googling and found this address sampler

 

[Deleted member 147267]

What comes to mind at the moment is using IsNumeric in a loop that tests each character moving from the right if your current code is catching that the first character is not a number. Then use Left or Mid once the position of the last numeric character is known.

 

[CJ_London]

or use the instrRev function to find the last space

PropNumber=mid(address,instrrev(address," ")+1)
Street=left(address,instrrev(address," ")-1)

edit missed the parameters

 

[peskywinnets]

or use the instrRev function to find the last space

PropNumber=mid(address,instrrev(address," ")+1)
Street=left(address,instrrev(address," ")-1)

edit missed the parameters

That worked a treat...thank you soooo much!

 

[Minty]

What comes to mind at the moment is using IsNumeric in a loop that tests each character moving from the right if your current code is catching that the first character is not a number. Then use Left or Mid once the position of the last numeric character is known.

@Micron Be careful with this one, I got caught out;

a-f are acceptable as hex numbers...

 

[isladogs]

I have a working solution for UK/US addresess, which typically follow this format

123 Station Road

but Germans Italians & Spanish etc reverse things, for example...

Via Trieste 22

...any ideas how I can break out the above to

22 (Property number)
Via Trieste (Street Name)

So, I need to start from the right of the string & locate the first space etc...but it's beyond me!

Many thanks!

Having spent a long time developing applications to work with UK postcodes and addresses, I would say there is no such thing as a typical address format. To see many examples that illustrate that comment, see Falsehoods programmers believe about addresses

 

[Uncle Gizmo]

but Germans Italians & Spanish etc reverse things, for example...

Well that's handy to know! I didn't know that... I know that I struggle reading Spanish address when I'm in Barcelona, I could never fathom them out. Simple when you know!