Page 1 of 1
Posted: Fri May 04, 2012 6:51 am
by chulett
A combination of the Convert() and CHAR() functions should do the trick, me thinks.
Posted: Sat May 05, 2012 1:34 am
by ray.wurlod
You need to know what codepoint em dash uses.
Posted: Sat May 05, 2012 7:20 am
by chulett
I'm assuming they already know this since they are successfully doing what is essentially the same thing in Oracle.
Posted: Mon May 07, 2012 1:18 pm
by goriparthi
Try This
TrimF(Convert(char(0):char(9):char(10):char(13),'-', ColumnName))
Posted: Mon May 07, 2012 11:23 pm
by krisna
Thanks everyone for the answers. How do i remove all unprintable characters before writing to a file.
Posted: Tue May 08, 2012 12:48 am
by ray.wurlod
By keeping only printable characters.
But is this really what you want to do? Some of these non-printing characters may be part of your client's valid data.
If you insist, use the "double Convert()" technique.
Posted: Thu Sep 27, 2012 6:57 am
by krisna
Used regexp_replace oracle function in source query to avoid unprintable characters.