|
|
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
|
|
Rank: Advanced Member
Joined: 2/27/2009
Posts: 565
|
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.
|
|
Rank: Advanced Member
Joined: 6/16/2006
Posts: 487
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):
|
|
|
guest |
