Add comma between values by using Linq

[NHoe (Norman)]

Hi all, I have a linq command that removes duplicate values, this works so far. What is new is that I need a comma after the OrderID, how can I achieve this?

That means if the input OrderID is “0815” I want to have “0815,” in the output.

(From d In DT_Input.AsEnumerable
Group d By k=String.Join(“,”,d(“Order_Number”).toString.Trim) Into grp = Group
Let ra = New Object(){grp.First()(1)}
Select r = DT_Clone.Rows.Add(ra)).CopyToDataTable

[supermanPunch (Arpan)]

Hi @NHoe ,

Could you Provide More details as to what are the Other Columns present in the Datatable or maybe post the Schema of the Datatable?

[Yoichi]

Hi,

The following code will add comma in OrderId column.

dt.AsEnumerable.ToList.ForEach(
Sub(r)
    r("OrderId")=r("OrderId").ToString()+","
End Sub
)

Sample20221111-5.zip (2.7 KB)

Regards,