unwanted characters inside the Datatable

[ahmeddc]

HI

I want to review an excel file after importing it from excel. And save the Excel file in datatable.
Also there might be unwanted Symbols or characters that I want to delete inside the Datatable
Symbols are not desirable {' / # ] [ $ % () ! "}

My unsuccessful method of identifying the symbol

For i = 0 To DT.Rows.Count - 1
If DT Is Nothing Then
Exit For : Exit Sub
End If
If DT.Rows(i).Item(i).ToString.Contains("'") Then
MsgBox("UNWANTED CHARE" & "EXCEL ROW NO" & DT.Rows(i).Item(i).ToString)
Else
MsgBox("GOOD")

End If
Next

Continue reading...