SOLVED
How to separate text into other column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Nurul
7 - Meteor
‎10-31-2017
10:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 ?
Size | Type |
SIZE : 10'H X 80'L X 2 | SIDED OVERHEAD BRIDGE |
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
2 REPLIES 2
JoshKushner
12 - Quasar
‎10-31-2017
10:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
‎10-31-2017
11:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot JoshKushner
