Start a new topic

2 regular expressions needed

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


Hi Ellen, great RegEx question!

 

RegEx one would be:

Replacement Value = 

Value to Match On = 

image

 

RegEx two would be:

Replacement Value = 

Value to Match On = 

image

I hope this helps, Keep up the good work!

 

Allison B.

Thank you! So helpful. Ellen :)
Login or Signup to post a comment