@Tim_Gentemann
Give a try on regex replace with following pattern and replacement:
Replace:
$2 (Space$2Space)
we do see that the space before / after is conditional. Also after the digit we would need a space (90765DE). On the Hausnummer it does fail if no space is needed. But depends on your requirements
In this case I just need to get the space before the first digit because everything after the house number (and the letter addition) will be deleted as it is saved to other variables.
I tried that regex with the regex.replace wizard but unfortunately I dont have the “SUBSTITUTION” section but the “Replacement” section.
When I type “$2” in Replacement, nothing happens. When I type " " the number gets deleted.
I tried both but unfortunately none of them solves the problem.
I have attachced the approach.
Would be very grateful, if you could do the same with your solution, so that I get what I do wrong. SplitNumberfromStreet.xaml (9.2 KB)