Split Street and Number to seperate Fields

[Anonymous]

Hello @all

I've got a database where I need to split one collumn into two.

For Example: I get from Database following Street Names:

Please mention the spaces at every end. (Every line is filled with spaces till it's filled to 40 characters)

Auf dem Berg 5                          
In der Grotte 7a                        
Über dem Weg 15b                        
Domstr. 12 am Damm                      
Wilhelm v. Geraldingen 3                
Im Garten 11                            

Now I would like to split it to 2 columns like:

Auf dem Berg	5
In der Grotte	7a
Über dem Weg	15b
Domstr.	12 am Damm
Wilhelm v. Geraldingen	3
Im Garten	11

There don't need to be spaces at the end.

I'm thinking about a function which counts the spaces, checks if it's a numerical value and then splits it....

Don't know if there is a better way. But I have no idea where to start with the funktion....

Maybe somebody of you can help myself? 

I already did the counting in a tMap... The maximum spaces between the names is 10 (like: "Hinter dem Weg der Grotte am Berg vom hohen Wangen 5")

Thanks and greetings

[Anonymous]

Hi,

    I would not recommend to parse the address data just by reading number of spaces. I believe its a German address and you will have to think of GDPR penalties if the address become wrong due to a simple programming mistake.

    My recommendation will to standardize the address using Talend components like tGoogleAddressRow. Below blog can give you a better idea about different components available in Talend for address standardization.

https://www.talend.com/blog/2019/07/30/standardization-of-customer-data/

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved