Linq Query To Remove Spaces

[JITU99 (jitendra)]

Hi

I have datatable with 4 columns.
I have to remove all the spaces from the first column for all the data rows and return the data table.

Can you help me with Linq Query.

[arjunshenoy]

Hi @JITU99

Can you share the sample input & desired output data, so that we can analyze your requirements?

Best Regards.

[JITU99 (jitendra)]

Input

Col1	Col2	Col3	Col4
AA bb c d e f d a asasd asd	asd	asd	asdf
a asrdg jikt hsf	wer	qwer	qwer

Output Datatable

Col1	Col2	Col3	Col4
AAbbcdefdaasasdasd	asd	asd	asdf
aasrdgjikthsf	wer	qwer	qwer

[arjunshenoy]

@JITU99

Please try this query in the Invoke Code activity:

io_dt.AsEnumerable.ToList.ForEach(Sub(row)
row("Col1") = row("Col1").ToString.Replace(" ","")
End Sub)

Invoke Code Arguments Panel:

Edit: Output be like-

Hope this helps,
Best Regards.

[ppr (Peter)]

@JITU99

I have to remove all the spaces from the first column for all the data rows and return the data table.

we would recommend using a for each
How to Update Data Column Values of a Data Table | Community Blog

The LINQ way could be used e.g. with DataTable reconstruction approach

Assign Activity:
dtCleansed = YourDataTableVar.Clone

Assign Activity:
dtCleansed =

(From d in YourDataTableVar.AsEnumerable()
Let c1 = d(0).toString.Trim.Replace(" ", "")
Let ra = d.ItemArray.Skip(1).Prepend(c1).toArray
Select r = dtCleansed.Rows.Add(ra)).CopyToDataTable