Trim the Column data

Help Studio
, , ,
1

Dear Forum Members,

I have a data table with large no of records and many columns has the space in every cell in starting and last of the cell data.

So i want the same data table but without the space.

Please help me with the linq query as data table has the many records.

Thanks in advance.

2

Assign Activity:
dtCorrected = dtOrigin.Clone()

Assign Acitvity:
dtCorrected =

(From r In dtOrigin.AsEnumerable
let ra = r.ItemArray.Select(Function (x) x.ToString.Trim()).toArray()
Select dtCorrected.Rows.Add(ra)).CopyToDataTable()
3

@ppr Thanks, It work fine.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.