Filter Wizard: variable contains letters

[Catia (Cátia)]

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

[bcorrea (Bruno Correa)]

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)

[Catia (Cátia)]

@bcorrea

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

Hey,

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:

[bcorrea (Bruno Correa)]

dont use the same name for argument and variable.

[Palaniyappan (Palaniyappan P)]

Here you go with an xaml
letteres.zip (9.8 KB)

Cheers @Catia

[WhenCutEsh (Venkatesh Nallana)]

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.