Home / Questions / 277557
Accepted
cosito
Asked: 2020-07-09 10:43:09 +0800 CST 2020-07-09 10:43:09 +0800 CST

Remove � when traversing rows

  • 772

When reading an excel file, there is information that contains hyphens "-"and when going through the rows and reaching one that has a hyphen it shows it as �, so when looking for none matches and does not perform any processing that I have.

Like what method can I use to remove the script when reading the rows, or replace it, some effective method.

I tried to use this string[] data = line.Split('-');but it didn't work.

c#

1 Answers

  1. Best Answer

    Could you help Replace()him while iterating the lines?

    something like being

    foreach(var line in lineas)
{
    line = line.Replace("-", " ");
}

    then you remove the -and leave the space

    string.Replace(String, String)

    • 1