Condition to Check the date Format

[Nipun (Nipun Vemula)]

Hello Guys,
My CSV file has a column with DOB, some dates have the “MM-DD-YYYY” format, while some have the “MM/DD/YYYY” format. I would like to know what condition we need to give in “if activity” to change only the rows that contain the “MM-DD-YYYY”.

[lakshman (Ganta lakshman)]

@Nipun

@Nipun

I would like to know what condition we need to give in “if activity” to change only the rows that contain the “MM-DD-YYYY”.

You can check string contains hyphen “-” or not like below.

        row("DOB").ToString.Trim.Contains("-")

[Nipun (Nipun Vemula)]

Thank You, Lakshman. Exactly what I needed