I am trying to isolate text that can appear in the following format in a string field.
7-23 or 100-22 or 17-23 --- so the text before the hyphen can be 1 or 3 digits, and the text after is a two-digit number with spaces on either side.
I am hoping the regex for this is relatively simple, but not finding examples when searching.
Solved! Go to Solution.
Can you share sample input and outputs.
Here are two examples --- with the expected result in ()
MAP for SI#303-22 (303-22)
SI# 3-23 Code of Conduct Training for Z's R&D (3-23)
(?:SI#\s*)?(\d{1,3}-\d{2})
@aehrenwo this works for your case
Thanks! worked great.