unprintable characters

chulett · Post by **chulett** » Fri May 04, 2012 6:51 am

A combination of the Convert() and CHAR() functions should do the trick, me thinks.

ray.wurlod · Post by **ray.wurlod** » Sat May 05, 2012 1:34 am

You need to know what codepoint em dash uses.

chulett · Post by **chulett** » Sat May 05, 2012 7:20 am

I'm assuming they already know this since they are successfully doing what is essentially the same thing in Oracle.

goriparthi · Post by **goriparthi** » Mon May 07, 2012 1:18 pm

Try This

TrimF(Convert(char(0):char(9):char(10):char(13),'-', ColumnName))

krisna · Post by **krisna** » Mon May 07, 2012 11:23 pm

Thanks everyone for the answers. How do i remove all unprintable characters before writing to a file.

ray.wurlod · Post by **ray.wurlod** » Tue May 08, 2012 12:48 am

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.

krisna · Post by **krisna** » Thu Sep 27, 2012 6:57 am

Used regexp_replace oracle function in source query to avoid unprintable characters.