REGEX to parse string to retrieve string before first occurence of character

[w_gore]

I've been trying different REGEX expressions to parse the following data to end up with string before first dash.  I struggle with REGEX expressions and think once I see how to do this request, the lightbulb will go off and i'll finally get it...i could use text to columns, but what's the fun in that.  thanks in advance.

204727-Production Well-ARC
3596-Borger 2000 Waste Oil Tank
3562-Woodhull 2000 Waste Oil Tank
3577-NY DEC REGISTERED TANK AST
204776-Quinlan 3000 Tank ARO 4678
1763831162-5250138-0000-1004
1763823538-5011221-0000-1004
1763846594-5161829-0000-1004

[DataNath · Accepted solution]

Hey @w_gore, if you use the RegEx tool in Parse mode with the following expression, you should be golden!

([^-]+)

This just captures everything that's not a dash until it runs into one.

[w_gore]

If all things could be this simple.  Thanks!

[DataNath]

No problem! It's also worth noting that for a simple request like this i.e. up to the first ... - regular string functions are also easy enough to add into the mix, like the following in a Formula tool:

Left([Input], FindString([Input], '-'))

Where we're just finding N (the index of the first '-') and then taking the first N characters from the left of the string.

[EN6924]

(\d+)-.* 

Parse, will also work.