IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Splitt Street Options · View
Boernd
Posted: Wednesday, December 9, 2020 7:54:45 AM
Rank: Newbie

Joined: 12/9/2020
Posts: 1
Hello,

i have the Problem to Splitt Adressdata into Street and Housenumber.

Input data:
Adress;
Street 1;
Street 2b;
Street 3 F;
Street Streat 4 H;

Output data should look like
Street; Housnumber;
Street; 1;
Street; 2b;
Street; 3 F;
Street Streat; 4 H;

Thanks for help
K101
Posted: Wednesday, December 9, 2020 11:31:13 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 438
Your example data doesn't really make sense at first glance. I suggest you attach actual example input and output files to your original post, perhaps along with whatever attempt you've made so far in MapForce.
that
Posted: Wednesday, December 9, 2020 4:20:07 PM
Rank: Advanced Member

Joined: 6/16/2006
Posts: 451
Location: AT
It appears that you want to split before the first occurrence of a numeric digit.

So we have two separate problems:
- Find the first digit
- Split the string there.

The second part is easy:
Street is right-trim(left(Address, subtract(find-first-digit(Address), 1))).

The right-trim will cut of the space before the digit. The subtract of 1 is to not include the first digit of the house number itself.

House number is even easier:
House number is substring(Address, find-first-digit(Address)).

The trickier part is how to implement find-first-digit. I'll attach an image.


that attached the following image(s):
find-first-digit.PNG

Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.