 |
 |
Archives of the TeradataForum
Message Posted: Mon, 06 Jul 2009 @ 17:10:28 GMT
| Subj: | | Re: Exporting Data with Ascii Characters in Field |
| |
| From: | | Rob Paller |
You could write a UDF that would retain only the printable characters in the field. There is a C function, isprint(), that will make the
process fairly straightforward. This would allow you to leverage the function elsewhere in your SQL instead of being limited to just the outmod in
a FastExport. There are other C functions to do similar tests that make great candidates for UDFs: isalpha and isnumeric.
| |
