Splitting HouseAddress

Help Studio
1

Hi! I’m reading a CSV-file that includes address like this:
Testaddress 18 B - H0201

I need to split it into:
StreetName: testaddress
HouseNumber: 18
HouseLetter: B
apartment number: H0101

I’m then gonna paste the different values into a program so i need the values seperate.
Anyone got some bright ideas.

2

@Ghagen

Welcome to forums

Check as below

image
image1036×524 24 KB

Split.xaml (6.1 KB)

Mark as solution if this helps

Thanks

4

Hi again! Thanks for the awesome and quick reply.

It solved my problem, but a new one arrived. Let’s say the StreetName: Test address
The StreetName needs to be ‘Test address’

Some of the addresses might contain several words, while others might just have one.
I was thinking to use Regex to separate numbers and letters? Tried to upload my workfile, but was not allowed since i’m a new user.

5

@Ghagen

Share to google drive and you can share the link

Thanks

7

Found the solution my self. Thanks anyway.