Hello, I would like to convert rows from String to Double using LinQ query. However I got this error message:
Some of my cells are empty… I would like to include a condition: If the cell is empty, then does nothing, otherwise converts. Do you have any solutions for me? Thanks
CorrectedInputDT = (From r In InputDT.AsEnumerable()
Let ab = r.ItemArray.take(18).Concat(r.ItemArray.skip(18).Take(5).ToList().ConvertAll(Function(a) CDbl(“0”+a.ToString.))).ToArray
Select CorrectedInputDT.Rows.Add(ab)
).CopyToDataTable
CorrectedInputDT = (From r In InputDT.AsEnumerable()
Let ab = r.ItemArray.take(18).Concat(r.ItemArray.skip(18).Take(5).ToList().ConvertAll(Function(a) CDbl("0"+a.ToString.))).ToArray
Select CorrectedInputDT.Rows.Add(ab)
).CopyToDataTable