Remove strange/special characters from string

[Angel_Llull (Angel95)]

Hello,

I am getting a csv and then to datatable, so I can match data, but I am facing that some sentences contains � this character. Due to this, some data is not matched.

Do you know how can I remove it from string?

PD: these does not work:

• myvar.tostring.replace(“�”,“”)
• for each row in dt: row(0) =String.Concat(row(0).ToString.AsEnumerable().Where(Function(x) Char.IsLetterOrDigit(x)))

[ppr (Peter Preuss)]

these dirty characters come in the majority when csv is read in within the wrong character encoding set

have a look here:

CSV to datatable to Excel // Encoding Problem

@Geoffroy_Pantegnies we assume that something with the character encoding is going wrong In RnD rounds we never use EXCEL for checking CSV data and are doing this with a text editor e.g. notepad++. (Excel can change the CSV data, while opening and also will not show us the details) So in a first round lets replicate and find out the encoding: sample text encoding: ISO 8859-1 : [grafik] will result to: [grafik] [grafik] when changing the encoding to: [grafik] we get: [grafik] Analysi…