Remove commas from a datatable

[Juan_Antonio_Goncalves_Ro (Juan Antonio Goncalves Rodrigues)]

Hello!

When I write two tables that I search in a bbdd, I join them with a “Merge Data Table” and then I write the resulting table in an excel but it comes out with these commas “,”
Do you know how I can remove the commas?

thxs!

[vrdabberu (Varunraj Dabberu)]

Hi @Juan_Antonio_Goncalves_Ro

→ Input:

Output->dt
→ Use the below code in Invoke code:

' Assuming dt is your DataTable
dt.AsEnumerable().ToList().ForEach(
    Sub(row)
        row.ItemArray = row.ItemArray.Select(Function(cell) If(TypeOf cell Is String, DirectCast(cell, String).Replace(",", ""), cell)).ToArray()
    End Sub
)

Invoked Arguments:

Output:

Regards

[tazunnisa.badavide (Taj)]

---->Input

dt_1.Rows.Cast(Of DataRow)().Where(Function(row) Not row.Field(Of String)("Column1").Contains(",")).CopyToDataTable()

Output

@Juan_Antonio_Goncalves_Ro Hope it works for u!

happy Automation

[vidyasreeb (SVR)]

dt1.AsEnumerable().ToList().ForEach(Sub(row) row.ItemArray.ToList().ForEach(Sub(e) e.ToString.Trim.Replace(“,”,“”)))