What I am trying to do is append the data in column “Value” data with “;300:_”.
Ex: 1625399;300:_
There are some values with alphabets in it as well which needs to be removed.
I can use for each to do it but I am trying to avoid that as there are almost 50K rows in the datatable and data coming from multiple sources. I am thinking of using LinQ to do it but I am not that good with the queries .
Can you please help me with it