Removing non-printing characters ... -- sql server (alternate)

ralph_noble NO[at]SPAM hotmail.com
10/7/2004 7:45:57 PM

Folks ... I have a pipe-delimited ASCII text file with a lot of
different non-printing characters. Rather than try and figure out all
the non-printing characters that exist in this 17+ million record
database, I was hoping someone might have already written a script
they'd be willing to share that would remove all non-printing
characters from an ASCII file?

Thanks,

Ralph Noble

Simon Hayes
10/8/2004 1:30:08 PM

[quoted text, click to view]

This isn't really an MSSQL question, so you'll probably get a better answer
in a forum for whatever language you usually use for tasks like this - Perl,
C#, VB etc.

Simon

sql server (alternate) : Removing non-printing characters ...