Replace ?

David Smith

14y1.8k

Hi what character is this in blue, I am trying to right logic to replace the question mark from a text file i am importing, can someone help me

(1.10 ? 1.49)

                            if (code.Contains('?'))
                            {
                                //Replaces a symbol character which comes over as '?' representing a dash with a real dash ('-').
                                code= pcodeDescription.Replace('?', '-');
                                cm.Parameters.AddWithValue("@code", code);
                            }

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Senthilkumar14y ago
Accepted answer
Hi Darnell,

you need to follow the encoding while reading the content from the file.

StreamReader sread = new StreamReader(Server.MapPath("Example.txt"),System.Text.Encoding.Default,true);
string strContent = sread.ReadToEnd();

This will show the content from your file as it is.

Hope this will help you.
David Smith14y ago
its not really a , read the file in and you will see what i am talking about.
David Smith14y ago
So if you read this file with one like and look at the weird character. I am trying to replace that character with a '-'. Review the attachment.
Read in the Example.txt file and what character c sharp is recognizing the character as (1.10 – 1.49) , when I read the file in code, i see the ', i am trying to replace it with a dash. or '-'
Senthilkumar14y ago
Hi,

When you use '' like this, then it will show the too many literals.
What you need to do is replace the ' quote by ".

string code = "1.10 1.49";
if (code.Contains('?'))
{
//Replaces a symbol character which comes over as '?' representing a dash with a real dash ('-').
code = code.Replace("", "-");
//cm.Parameters.AddWithValue("@code", code);
}

It works, check it and let me know.
David Smith14y ago
sorry for the inconvience, that was an copy and paste error., but the code is not recognizing the character as a ?, when I step through the code and look at the variable the character look like this '' , so it's not recognizing the question mark at all. What I am going to do is post an the actual line I am parsing from a file and see if you can parse and replace the character. in the text file it's a dash, but when I read it into memory or code, the dash shows as . give me 5minutes I am going to attach a file.

if (code.Contains('?'))
                            {
                                //Replaces a symbol character which comes over as '?' representing a dash with a real dash ('-').
                                code= code.Replace('?', '-');
                                cm.Parameters.AddWithValue("@code", code);
                            }
Senthilkumar14y ago
Hi Darnell,

What ever you have written the logic is correct.
But you are not replacing the "-" from the correct variable.

Instead of this
code= pcodeDescription.Replace('?', '-');

you need to do like this
code= code.Replace('?', '-');

Working code here:

string code = "1.10 ? 1.49";
if (code.Contains('?'))
{
//Replaces a symbol character which comes over as '?' representing a dash with a real dash ('-').
code = code.Replace('?', '-');
cm.Parameters.AddWithValue("@code", code);
}