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