I extracted an data table from MS Access. The issue is, that after pasting it in Excel in many rows of data table the word “Schaltfläche”.
I want to delete this whenever it occurs, and to delete empty spaces (trim data).
I know how to trim/delete/replace text in one cell of data. But how can I do this with whole dt/Excel table?
Hi @lucas.mcgonagle You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: System.Data.DataSetExtensions Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup
Not sure if I can take a risk and jeopardize the complete work.
Thanks - it works. It cleans and trims the data.
But I am having a troupe with outputing it.
It builded new dt, and tried with add data row activity. That did not worked well. Data is not properly structured - what should be in columns is stacked into rows.
So I am trying with add column activity. I never used this one, so it is not working as well