public void CleanColumn(string columnName) { if (!Columns.Contains(columnName)) { return; } Logger.LogMessage($"\nCreate temporary data list"); List <string> tempList = GetRows(columnName); Logger.LogMessage($"Create DataCleaner, ready to clean {tempList.Count} rows"); DataCleaner dataCleaner = new DataCleaner(tempList, columnName); var cleanedData = dataCleaner.Clean(); for (int i = 0; i < cleanedData.Count; i++) { try { DrugDataTable.Rows[i][columnName] = cleanedData[i]; } catch (Exception ex) { Logger.LogError(ex.Message); } } Logger.LogMessage($"Data has been updated in Dataset successfully\n"); }
private void TrimDataset() { Columns.ForEach(column => { var cleaner = new DataCleaner(GetRows(column), column); var trimmedData = cleaner.TrimColumn(); for (int i = 0; i < trimmedData.Count; i++) { try { DrugDataTable.Rows[i][column] = trimmedData[i]; } catch (Exception ex) { Logger.LogError(ex.Message); } } }); }