Strange Things Happening When Reading Data From A File

[Smeat]

Hi All

When reading data from a text file using the StreamReader class it is adding unwanted characters to the data.

When I read my text file using NotePad it looks like this:


"","","1-RF98G","ENU","","Jones",


When I read it into a string variable using the following code:

System.IO.StreamReader s = System.IO.File.OpenText(ImportFile);

  int counter = 0;
  while (s.Peek() > 0)
  {
    counter ++;
    //Loop through each record
    string @row = s.ReadLine();

    ....

The contents of my string variable look like this:


"\"\",\"\",\"1-RF98G\",\"ENU\",\"\",\"Jones\",


Anybody know why this is happening?

Anybody know how to stop this happening?

TIA

Smeat

 

[misterstick]

if this is displayed in the watch window, don't worry,
it's just the way visual studio displays quotes inside strings.

the extra slashes aren't really there.

write the strings out again and you'll see.


mr s. <

 

[Smeat]

Unfortunately this is not just in the watch window, these additional characters are being assigned to my variables so when I do comparisons with expected values the comparisons fail.

Any ideas ?

Ta

Smeat

 

[litton1]

will it work as thought if you change the line

string @row = s.ReadLine();

to

string row = s.ReadLine();

??

Age is a consequence of experience

 

[Smeat]

Unfortunately this makes no difference.

 

[dseaver]

Did you try/Does the following help?

string @row = s.ReadLine().ToString();

 

[litton1]

I guess there are a couple options that I can see...

1. Before writing the data to a file do a myString.Replace... and use a different character such as a tilde?

char apos = (char) 34;
char replace = ( char ) 126;
myString.Replace( apos, replace );

2. Change the string values to bytes i.e.

byte[] myChars = (byte) myString.ToCharArray()

(not tested or preferred)

maybe some others..

Age is a consequence of experience

 

[JurkMonkey]

If you are trying to save the string in a consistent manner that is not going to cause havoc, then look at the web classes. When you write in HTML you use tags like &quote

There are classes that can do this conversion for you in both directions.

http://www.ubuntu.com/

 

[chiph]

It's almost certainly Visual Studio putting those characters in there in the debugger.

To prove this, after reading from your file, immediately copy the contents of your stream to another file, and open it in Notepad. It won't have the extra slashes.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[JurkMonkey]

The beauty of escape sequences.

http://www.ubuntu.com/