Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to separate text into other column

Nurul
7 - Meteor

Hello,

 

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

Size
SIZE : 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 ?

 

SizeType
SIZE : 10'H X 80'L X 2 SIDED OVERHEAD BRIDGE 
2 REPLIES 2
JoshKushner
12 - Quasar

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

A sample workbook is attached.

 

Flow:

Flow.PNG

 

Results:

results.PNG

 

 

Regex:

regex.PNG

 

Nurul
7 - Meteor

Thanks a lot  JoshKushner

Labels