SEPARATE THE DATE AND LETTER VALUES FROM A COLUMN

Question

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 20190000034179  1008200000262051 10052001.13.201/1/20201/2/2020010220 RE APP1031912720082020 INCOMPLETE DETAILS8/17/20208/19/20208/25/20208/27/2020

To this:

Effective Date1/1/20201/2/20208/17/20208/19/20208/25/20208/27/2020

Hope you could help me with this one! Thanks

messi007 · Accepted Answer

@dunkindonut7777,

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

Please see below:

Hope this help!

Attached the workflow.

Regards

afv2688 · Accepted Answer

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