[dba-VB] C# replace a special character

I think the overhead of RegEx would be too high on a really large
replace.  It works great, but it isn't the fastest way.

Charlotte Foust 

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Jack and Pat
Sent: Tuesday, October 20, 2009 9:27 AM
To: 'Discussion concerning Visual Basic and related programming issues.'
Subject: Re: [dba-VB] C# replace a special character

John,

I did a google search to find this link. I'm not a C# person, but
thought I'd pass this on

http://dotnetperls.com/regex-replace-1

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, October 20, 2009 11:45 AM
To: VBA
Subject: [dba-VB] C# replace a special character

I have a file which contains a sprinkling of a special character -
decimal 26, hex 1A (the SUB character).  This special character in the
CSV file output to Accuzip causes Accuzip to hiccup.  In order to get on
with my life I need to pre-process the files to get rid of this special
character. 
Because of the size of these files (hundreds of mbytes) I need to do a
readline / replace / writeline kind of thing.  I think I need to use the
stringbuilder.replace but I do not know how to specify replacing this
hex 1A with something else.  The something else would ideally be nothing
(empty string) but can be any valid alpha character (A, B etc).

Can anyone help me with this replace part of the problem.  C# syntax
please.

--
John W. Colby
www.ColbyConsulting.com