I need help with 2 regular expressions.

I have IDs # in my file that I need to parse.  I do know how to split the ID# in Excel using text to columns but we will be getting files to import daily and I’m hoping that IMO can automatic this step.

The ID# is in this format: 24566-ECV16.

I.e., it will have 5 or more digits followed by a dash then 4 or more characters. 

I need an expression that will return only the ID# number that appears before the dash.

And, a second expression that will return the ID# that appears after the dash.

E.g.

Expression one returns: 24566

Expression two returns:  ECV16

Thank you,

Ellen Liebner