Hi, I would like to separate example below into 2 columns - First column only with numbers and other with rest: Input14 Norbury StreetFairwood drive 22Althostrasse 5 Expected Output 1Expected output 2 14Norbury Street22Fairwood drive5Althostrasse 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!

Splitting Words and numbers into separate columns.

boroalicja2

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!

Regex

Accepted answers

BS_THE_ANALYST

Parse the letters and numbers out separately I guess! Would be annoying with postcodes involved? @boroalicja2

RegexAddress.yxmd

Amy_smart

For the Regex, expected output1 is (\d+) with a parse and expected output2 is (\d) with a replace of nothing.

BS_THE_ANALYST

@boroalicja2 if it does contain postcodes, remove them via the RegEx replace (then continue with the steps highlighted above):

All comments

Amy_smart

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

messi007

@boroalicja2,

Please see below :

Attached the workflow,

Regards

RegEx20230720.yxmd

BS_THE_ANALYST

Parse the letters and numbers out separately I guess! Would be annoying with postcodes involved? @boroalicja2

RegexAddress.yxmd

Towers

@boroalicja2 this should work for you.

Screenshot 2023-07-20 150605.png

Regex.yxmd

Amy_smart

For the Regex, expected output1 is (\d+) with a parse and expected output2 is (\d) with a replace of nothing.

BS_THE_ANALYST

@boroalicja2 if it does contain postcodes, remove them via the RegEx replace (then continue with the steps highlighted above):

boroalicja2

Thank you all for help!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335