I need to take the middle string of consecutive characters and the rightmost section of consecutive numbers, and connect them with - (if there is a 0 or 2 zeros between the character and the last non-zero number, they must be removed):
I tried to write a lookup regular expression, FINDREGEX:
`
([a-zA-Z]\d+|\d*)([a-zA-Z]+)0{0,2}(\d{1,5})
`
REPLACE_REGEX:
\2-\3
I tried to write a lookup regular expression using () to define the grouping, but I can't use \n to reference the grouping in the replacement regular expression.
Can anyone help me with how to write a regular expression? Thank you in advance.
some source searchTerms:
I need to take the middle string of consecutive characters and the rightmost section of consecutive numbers, and connect them with - (if there is a 0 or 2 zeros between the character and the last non-zero number, they must be removed):
I tried to write a lookup regular expression, FINDREGEX: ` ([a-zA-Z]\d+|\d*)([a-zA-Z]+)0{0,2}(\d{1,5}) `
REPLACE_REGEX:
\2-\3
I tried to write a lookup regular expression using () to define the grouping, but I can't use \n to reference the grouping in the replacement regular expression.
Can anyone help me with how to write a regular expression? Thank you in advance.