C# - Replace newline character in a text file

[GoalieDude]

My problem is that I'll receive a large excel file from a customer that has hard return in one of the cells (i.e. pressing alt + enter to make a new line in a cell) and when I export it to a text file, the value for that cell will have quotes around it and have an unknown/unreadable character (the little boxes) inline with the text. I would like to use C# to build an application to batch check for this kind of error but I can't figure out how to remove the newline character that is in the text file. Any help would be much appreciated.

[Plater]

I recomend reading the data in and examining what the byte values of those characters are, to make sure you have them correct.
Then in your program you can read in the string and do a .Replace(TheVal ueOfThoseBytes, ""); to remove them.

[GoalieDude]

Thanks - that works really well. Now my next question is that say I want to define my own delimiters to search between - in my case quotation marks - how would you go about doing that? Is it possible in C#?

[Plater]

Well if your delimeters are already in the file, you can use the .Split() function to create an array of each of the sections between delimeters.