Omatic Support
How can we help you today?
2 regular expressions needed
2 CommentsSorted by Oldest First
Hi Ellen, great RegEx question!
RegEx one would be:
Replacement Value =
Value to Match On =
RegEx two would be:
Replacement Value =
Value to Match On =
I hope this helps, Keep up the good work!
Allison B.
Thank you! So helpful. Ellen :)
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