Check Column in datatable has cell with special date format

Hi Everyone.

I have a datatable with 4 columns , i want to check the first col has any cell contain date format “\d{2}/\d{2}/\d{4}” and then return true.

How to do this with IsMatch activity or any other.

Thanks in advance!


Can you try the following expression?

dt.AsEnumerable.Any(Function(r) System.Text.RegularExpressions.Regex.IsMatch(r("Column1").ToString,"\d{2}/\d{2}/\d{4}"))


1 Like

Thanks you very much!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.