Filter Wizard: variable contains letters

Hey everyone,

I hope you can help me. I have a data table, and one column is suppose to have only numbers. However, there is a small chance of mistake, and accidentally I could have letters mixed up. I want to create a filter that removes this rows.

Any ideas?

Thank you

1 Like

This would delete the rows but cannot be used in assign, nees an Invoke code activity

dt.Rows.Cast(Of DataRow).Where(Function(r) IsNumeric(r.ItemArray(0))).ToList.ForEach(Function(r) r.Delete)


I never used this activity. I put the arguments, but there is an error because I’m not producing a value. I put this arguments:

dont use the same name for argument and variable.

Here you go with an xaml (9.8 KB)

Cheers @Catia

So what are you gonna do with the rows that are having letters, are you gonna write some logic there??
Why don’t you try to correct them rather than removing.

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