Replace ?

Question

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); }

Senthilkumar · 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.Defaulttrue); string strContent = sread.ReadToEnd(); This will show the content from your file as it is. Hope this will help you.

David Smith · Answer

its not really a  read the file in and you will see what i am talking about.

David Smith · Answer

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 '-'

Senthilkumar · Answer

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 Smith · Answer

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); }

Senthilkumar · Answer

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); }