[REGEX] I need to extract the expression "d-d-dd"

[BautistaC888]

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.

[Biswarun]

A pattern can be [0-9]{1}-[0-9]{1}-[0-9]{2}

[Matthew · Accepted solution]

this should do the trick

REGEX_Replace([Field1], '.*(\d-\d-\d{2}).*|.*', '$1')

[binuacs · Accepted solution]

@BautistaC888 One way of doing this with the RegexTokenize 

[Emmanuel_G · Accepted solution]

Hi @BautistaC888 ,

Find attached the way to do that