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?
Use a For Each Row activity, then inside that, use a For Each activity iterating over row.Table.Columns. This will iterate over every cell of the table.
“change the statement from row.Table.Columns to ExtractDataTable.Columns.toList” - I can´t do this. I am getting message ‘toList’ in not a member of ‘System.Data.DataColumnCollection’
It might be, that I am doing something wrong.
Here is again the workflow.
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
Blockquote
Not sure if I can take a risk and jeopardize the complete work.
Hi again!
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