ebertsys
asked on
Extract Housenumber from street field
I get the problem to extract the housenumber from street adress.
i have to create 2 fields one with street and one the number.
in most cases they are delimited with a blank char.
tx.
i have to create 2 fields one with street and one the number.
in most cases they are delimited with a blank char.
tx.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
first create 2 colums on for street and one for numbers.
we have also HillStr.32
so we must do it step by step..and the rest will do an appl. found in internet who gives all adresses worldwide..1000adresses 40€