how can I extract the number part without for each row then read cell?
So what I understand from your solution is, extract all the values then regex to get the number part, and linq to filter for getting the result datatable, which I think can work but how can I extract the values in single execution and apply regex for all?
For the learning purpose I would suggest to Run the linq / Code Just to Explore and inspecting the result.
About your question I am Not Sure If I got you in total. Let US Balance Out the technics and your expectations. Regardless If IT is a oneLiner or Not some how all rows are to Check for filtering. So IT IS Looping internally anyhow.
May we ask you just to resharp your question and help us to understand it better. Thanks
Okay let me clear myself then.
Yes I understood when using linq its looping internally I’ve read the link u send.
I understand what you are trying to do with the linq, its filtering the rows where number>30. What I didnt get is.
Let sv= regex.match(d(“Number”). toString,\d+).toString , I didnt quite understand here.
And I get this error trying to use this linq
Okay then we assign it to iv and if its more than 30 we select that value and copytodatatable, makes sense.
I didnt know you were helping me from your cell , thank you very much you are a legend.
Dont waste your time on your phone to do it. Let me know when you are available from your laptop, again thank you .