How to delete all dates in a column that do not match format in Studio X

Help StudioX
,
1

Hello,

I have an excel column with dates and I want to remove all cell values that do not match these formats. i.e 1/11/2023 or 11/2/2023. An invalid date would like 0222, 20222, etc.)

Any help is appreciated.

Thanks

2

The Regex can be used for the Column to identify the matched columns .

based on the requirement , the rest of the items can be deleted or skipped.

3

@vielesh

Use a for each row in excel sheet

Then use if condition inside to check if the string contains slash currentrow("Columnname").ToString.Contains("/")

Then inside the then condition use delete row

Cheers