I want to extract the first and second dates that have been included in free-text memo lines. The dates are either 1/1/2021 or 01/02/2021. I'm thinking I use something like REGEXP_SUBSTR({memo}, '[d\s]d\/[d\s]d\/\d\d\d\d') but that returns null.

Something like this should work

thanks. ended up with REGEXP_SUBSTR({memo}, '\d{1,2}/\d{1,2}/\d{4}',1,2)