I have a datatable which I delete the rows where the rows “first quantity” and “second quantity” column values match.
But sometimes the excel is exported faulty and for examle,
first quantity value is 72 and second quantity column value is 72000, but actually this a column I want to delete.
So is there a way I can do something like; if second column quantity value includes first quantity columns value, remove that row from datatable?
Since “72000” includes “72” it could do the job for me.
(Also I cannot use for each row because there are 15000 rows so it takes alot of time)
I need tomething like :
(From d In dtMainData.AsEnumerable
Let k1=d(“first quantity.”).ToString
Let k2=d(“second quantity”).ToString
if k1.contains(k2)(delete row)
Something like this
Thank you very much