Remove $ from the column of sheet

Hi Team,
Hope you are well. I need help.
i have column with $ sign. I would like to be removed.

Please find attached the excel file. Can you please share me the xaml?

ask_uipath.xlsx (8.9 KB)

Hello @srinivas_pradeep

I think the below expression can help you to achieve this…

DT= DT.AsEnumerable().Where(Function(a) a.Field(of string)(“yourcolumnname”).ToString.Replace(“$”, ””).ToString).CopyToDatatable()

where DT is the datatable which you will receive after reading the excel.

1 Like

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