How to separate text into other column

Question

Hello,

I new in Alteryx and have a problem to separate two information.

SizeSIZE : 10'H X 80'L X 2 SIDED OVERHEAD BRIDGE

I have this column which contains two information like table above.How can I separate the two information become table below ?

SizeTypeSIZE : 10'H X 80'L X 2 SIDED OVERHEAD BRIDGE

JoshKushner · Accepted Answer

You can split that text with Regex. I personally prefer to test my Regex at https://regex101.com/.

A sample workbook is attached.

Flow:

Results:

Regex: