Hi,
I would like to separate example below into 2 columns - First column only with numbers and other with rest:
Input |
14 Norbury Street |
Fairwood drive 22 |
Althostrasse 5 |
Expected Output 1 | Expected output 2 |
14 | Norbury Street |
22 | Fairwood drive |
5 | Althostrasse |
I know it can be done using RegEX but tried few times and I can't get it right .
Thank in advance for any help and clues how to solve it!
Solved! Go to Solution.
Hi boroalicja,
The simplest solution is to duplicate the fields and use the data cleansing tool. For expected output 1, remove the letters. For expected output 2, remove the numbers.
Thanks,
Amy
Parse the letters and numbers out separately I guess! Would be annoying with postcodes involved? @boroalicja2
For the Regex, expected output1 is (\d+) with a parse and expected output2 is (\d) with a replace of nothing.
@boroalicja2 if it does contain postcodes, remove them via the RegEx replace (then continue with the steps highlighted above):
Thank you all for help!