Hi, I have just started working with PDI two weeks ago, and there is something I can't figure out (even after reading other posts about this topic).
I have a column with an address, which can have either of the formats below:
Aagje Dekenlaan 1
Jacoba van Beierenlaan 1
Buitenwatersloot 1 B
Jacoba van Beierenlaan 1 B 1
Jacoba van Beirenlaan 1 B-1
Jacoba van Beirenlaan 1 B1

Where each "1" could have a value of 1-1000
I would like to split this column into three columns, but I can't seem to make it work correctly. I have tried the regex function with different suggestions I found on Google, but it seems that the inconsistent way in which the data in this column is organised messes every function I have tried up.
The way I would like to organise it:
Aagje Dekenlaan 1
Jacoba van Beierenlaan 1
Buitenwatersloot 1 B
Jacoba van Beirenlaan 1 B 1
Jacoba van Beierenlaan 1 B-1
Jacoba van Beierenlaan 1 B1
So only words in the first column, only numbers in the second, and what is left in the third.

Is this even possible in PDI? And if so, which expression should I use for it?