How would I filter specific format data

[Bansi08]

Hi there -- I have column in the table as per below. I want to filter out only date formatted data and rest all should be eliminated. I am beginner level alteryx user. Please guide me on this. 

Column Name
0:00:00
Alpha
Beta
[null]
total
SOP
As of 03/31/2023
Date
Total Value
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31

Output data

Column Name
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31
2021-09-15
2021-03-25
2022-06-30
2022-07-31

[Prometheus · Accepted solution]

You could use a Filter tool with the expression: REGEX_Match([Column Name], '^\d{4}\-\d{2}\-\d{2}') to only allow records to pass that match the pattern specified in the regular expression. Take a look at www.regex101.com for help with regular expressions.

 

[grazitti_sapna]

Hi @Bansi08 Parse tool - Date Time solve it in easy way!
Kindly Check. Hope it works for you 
Thanks

[Bansi08]

Thanks both for your solution.