Does anybody know how to insert a space before the first number in a string?
Thanks in advance for your help!
Give a try on regex replace with following pattern and replacement:
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
Thanks a lot for your prompt answer!
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.
replacements can be configured here:
or use Regex.Replace(yourString, YourPattern, YourReplacement)
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)