Dear users,
Â
I have a string attribute stored in a field for >150k point features including addresses, numbers, and sometimes additives.
Â
Three examples of addresses:
Â
Maria van Reedestraat 9-BS
Eduard Künnekehof 1
Bucheliusstraat 11-BS
Â
What I would like to have, is a new attribute indicating only the street name (= everything before the last space) and a new attribute only having the street number plus additive, which matches everything after the last space.
Â
I have found some tips regarding regular expressions, but I haven't found a way out yet.
Â
Any help would be appreciated!
Â
Thanks in advance,
Â
Martin