SEPARATE THE DATE AND LETTER VALUES FROM A COLUMN

[dunkindonut7777]

Hi I would like to ask if how could I separate the date type of value from the letter values.

From this:

Effective Date

& ANNUAL RECOGNITION 2019

0000034179  100820

0000262051 100520

01.13.20

1/1/2020

1/2/2020

010220 RE APP

10319

12720

082020 INCOMPLETE DETAILS

8/17/2020

8/19/2020

8/25/2020

8/27/2020

To this:

Effective Date

1/1/2020

1/2/2020

8/17/2020

8/19/2020

8/25/2020

8/27/2020

Hope you could help me with this one! Thanks

[Qiu]

@dunkindonut7777 
I think we can use RegEx

[messi007 · Accepted solution]

@dunkindonut7777,

You can do this with the filter tool using contains "/"

Please see below:

Hope this help!

Attached the workflow.

Regards

[afv2688 · Accepted solution]

Hello @dunkindonut7777 ,

Using a filter tool with the following formula should be enough to get all the dates:

REGEX_Match([Effective Date], '\d+/\d+/\d+')

Regards