Can you help me split this data into two columns?
0123-4869 - Asset Cat 23 |
4589-6592A - Jones Switch |
FAC24360 - Build Hydro |
0001-4578 - Cart. ISW4596 - Row |
FDU2314 - 42509 SQ FT Warehou |
6LIFD87 - 3" NIT53: ONE |
I am trying to split into two columns and for the results to look like this
0123-4869 | Asset Cat 23 |
4589-6592A | Jones Switch |
FAC24360 | Build Hydro |
0001-4578 | Cart. ISW4596 - Row |
FDU2314 | 42509 SQ FT Warehou |
6LIFD87 | 3" NIT53: ONE |
Solved! Go to Solution.
Hey @GARCIAJ8,
Here is one way to do this:
Regex is not always perfect but my regex creates a group on the first word then creates another group on all the other text.
If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20...
Any questions or issues please ask :)
HTH!
Ira
Hi @GARCIAJ8
Based on your data you don't need regex:
Just to breakdown my Answer a bit:
(\<\w+\>)\s-\s(.*)
The brackets () creates the two groups. Group 1 (\<\w+\>) is a word then \s-\s is the space the dash and another space. Finally the last group captures everything else (.*) .