Removing non-printing characters ...

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
ralph_noble@.hotmail.com"Ralph Noble" <ralph_noble@.hotmail.com> wrote in message
news:ed6de1e7.0410071845.36258199@.posting.google.c om...
> 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
> ralph_noble@.hotmail.com

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