SEPARATE/EXTRACT THE DATE IN THE COLUMN

[dunkindonut7777]

Hi I have a data here that has a column which contains description and a date. I want to extract the date only. How can I separate it using the values below:

Journals	Date (expected output)
CCPI-JV-1003632 - CCPI Coral Asean Periodic, Inc. - 07/01/2021 - Salaries Accrual for May 2021 (Reversal)	7/1/2021
Operational Journal: CCPI Coral Asean Periodic, Inc. - 07/01/2021	7/1/2021
CCPI-JV-1003767 - CCPI Coral Asean Periodic, Inc. - 07/01/2021 - CCPI open PO for accrual FY2021 (Reversal)	7/1/2021

How can I extract these?

[caltang · Accepted solution]

You can use REGEX as follows:

(\b\d{1,2}/\d{1,2}/\d{4}\b)