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.
Ellen Liebner
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