Parse String with Letters and Numbers

[jatienza]

Hi,

Need help in parsing the raw data below. Output is also given below.

Raw Data

add

England EC2A 4

London N1 9QS

South Yorkshire  S60 1DL

NORTHUMBERLAND

Tyne and Wear CH45 4JL

Kent BR6 8NL

England

Wales 89B

England DN5 0

Output

add1	add2
England	EC2A 4
London	N1 9QS
South Yorkshire	S60 1DL
NORTHUMBERLAND
Tyne and Wear	CH45 4JL
Kent	BR6 8NL
England
Wales	89B
England	DN5 0

[BS_THE_ANALYST · Accepted solution]

@jatienza Nice challenge!

[jatienza]

@BS_THE_ANALYST it's working but doesn't work if it is in Uppercase like this one:

add	add1	add2
WEST YORKSHIRE BD5 7HF	WEST	YORKSHIRE BD5 7HF

[BS_THE_ANALYST]

@jatienza can you try this regex instead:

^([a-zA-Z ]+)(?:\s+([A-Z0-9 ]*))?$

I can't test it using Alteryx as I'm out at the moment. Can you see if that code works!

[jatienza]

@BS_THE_ANALYST it is working now. Thanks a lot.