RegEx tool: Spilt into two columns

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

Input

Regex

Custom Tools

Accepted answers

@GARCIAJ8 one way of dong this

Regex_19_07.yxmd

All comments

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%20Data

Any questions or issues please ask
HTH!
Ira

Based on your data you don't need regex:

Text to columns on the first space
Remove first 2 characters

New Workflow3.yxmd

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 (.*) .

@GARCIAJ8 one way of dong this

Regex_19_07.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15867

MarqueeCrew 13708

apathetichell 13703