Stripping unknown characters
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home   
Search
    Guidelines    Member List
Welcome Guest ( Login | Register )
     
Recent Posts
   
Popular Topics

Teradata Discussion Forums » Teradata » Data Warehousing » Stripping unknown characters
This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


Stripping unknown characters Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
JustMe
Posted 4/30/2008 1:36:06 PM
Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Forum Members
Last Login: 6/4/2008 10:34:59 AM
Posts: 21, Visits: 23
How can I, in a select statement, strip "garbage" characters from a column in my result set? For example, we have a table that was loaded by another application, and some of the values contain what looks like a carriage return character.
Post #11332
SN
Posted 5/1/2008 9:47:39 AM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 8/11/2008 3:00:36 PM
Posts: 76, Visits: 147
can you give an example of the data format in the table?

-SN
Post #11336
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 3:07pm

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.078. 9 queries. Compression Disabled.