Hello, does anyone know how to remove some non-printable characters from a string in a column? I imported data via OLE-LOAD from a MS SQL server. At least one column contains '0D0A'XB or '0A'XB. This delivers undesired results when exporting via Parallel transporter. So I have to remove those hex Strings, but

I want to replace all of the whitespace and non alphanumeric characters in a string. It seems like some form of the following should work:

Hi All I'm trying to implement Oracle REPLACE() function in teradata using SQL statements only. I searched the forum , but found Oreplace() UDF as the only solution.  Can someone help me in implementing this is pure teradata SQL  ??  Thanks Praneeth

Hi,           Need Help on Replace Function   Senario: There is column with Value:  Text1 , Text2 , Text3; Need to Replace it as Text1 Text2 Text3   Other Information: 1. OREPLACE function is not installed, Please help me with other possibilities

I am running a query that returns blling data with an account number that contains "." in no set position. What I need to do is replace the period "." in each instance that it occurs with a forward slash "/". I have read many items related to using UDF's, however I do not own the server and have no idea if any UDFs are actually loaded.

Hello,