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
Solved! Go to Solution.
@dunkindonut7777
I think we can use RegEx
You can do this with the filter tool using contains "/"
Please see below:
Hope this help!
Attached the workflow.
Regards
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