Remove the Rows contains Only Integer value

[ShekharRPA (Shekhar Gupta)]

Hi,

I Have a table

and i want to remove the rows contains only digits. Pls help

[arivu96 (Arivazhagan A)]

Try below code

Dim myregex As Regex = New Regex("[0-9]")

datasetB.Select().
    Where(Function(r) myregex.IsMatch(r.Item("ColumnName").ToString())).
    ToArray()

Regards,
Arivu

[Gokul001 (Gokul Balaji)]

HI @ShekharRPA

Try this expression

YourDatatableName.AsEnumerable().Where(function(r) Not System.Text.RegularExpressions.Regex.IsMatch(r.Field(Of String)("Column Name"), "[0-9]")).CopyToDataTable

Regards
Gokul

[ShekharRPA (Shekhar Gupta)]

If No column name is there.?
Also I want only remove the digits rows and any special characters with digit.

[Gokul001 (Gokul Balaji)]

HI @ShekharRPA

Here is the workflow and excel file

Numeric.xlsx (9.0 KB)
RemoveNumeric.xaml (7.4 KB)

Expression
Dt.AsEnumerable().Where(Function(x) not System.Text.RegularExpressions.Regex.IsMatch(x("Numeric").ToString.Trim,"^[0-9.]")).CopyToDataTable

Regards
Gokul

[ashwin.ashok ((TheCodingTheory))]

Hi @ShekharRPA ,

Could you try this and see if it works out for you?

(From row In Dt.AsEnumerable()
Where Not row(0).ToString.IsNumeric()
Select row).CopyToDataTable()

Kind Regards,
Ashwin A.K

[ShekharRPA (Shekhar Gupta)]

Thanks @Gokul001