Hello,
I need help with regular expression to extract data (d-d-dd) from a field:
I have expressions like: "443-1166510-0-34 - FIDISO JE PiO"
I need to extract the numbers: "0-0-34" in the middle of the string
Thank you.
Solved! Go to Solution.
A pattern can be [0-9]{1}-[0-9]{1}-[0-9]{2}
this should do the trick
REGEX_Replace([Field1], '.*(\d-\d-\d{2}).*|.*', '$1')