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!

[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

[BS_THE_ANALYST · Accepted solution]

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

[Towers]

@boroalicja2 this should work for you.

 

[Amy_smart · Accepted solution]

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

[BS_THE_ANALYST · Accepted solution]

@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!