Check Column in datatable has cell with special date format

[Mr.H]

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!

[Yoichi]

Hi,

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}"))

Regards,

[Mr.H]

@Yoichi

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

Thanks you very much!