How can i parse dates with different formats and positions?

[BautistaC888]

I need to get the dates on another column but the formats and positions of the dates are different.
Thank you.

[afv2688 · Accepted solution]

Hello @BautistaC888 ,

try to use this formula:

REGEX_Replace([Observación], '(.*\s)(\d+[\-|\/]\d+[\-|\/]\d+)(.*)','$2')

Regards