[dba-VB] C# replace a special character

Jack and Pat drawbridgej at sympatico.ca
Tue Oct 20 11:27:20 CDT 2009


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
_______________________________________________
dba-VB mailing list
dba-VB at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-vb
http://www.databaseadvisors.com





More information about the dba-VB mailing list