How to check if the columns of datatable contains string

Hi All,

I want to check if datatable column second , third , 4th contains string if yes then convert them into zero.

1.) Use a For Each Row activity on your datatable.
2.) Add 3 If activities into the For Each Row loop with conditions Not String.IsNullOrEmpty(row(1).ToString), Not String.IsNullOrEmpty(row(2).ToString), and Not String.IsNullOrEmpty(row(3).ToString).
3.) In the Then block of each If statement, add an assign statement with the left side set to row(1), row(2), and row(3) for each respective If statement, and the right side set to "0".

1 Like

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