Strip Linefeed/Tab characters

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

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.

Strip Linefeed/Tab characters

Rate Topic

Display Mode

Topic Options

Author

Message

anil4yesu

Posted 9/23/2009 1:59:08 PM

Forum Newbie

Group: Forum Members
Last Login: 9/23/2009 6:27:09 PM
Posts: 3, Visits: 18

I have notes field VARCHAR(72) that has some linefeed/tab characters. Is there an easy way to strip them off. I tried replace(col1,'OA'XC,' ') but it didn't like it.

Thanks
Anil

Post #16915

jimm

Posted 9/23/2009 3:05:06 PM

Supreme Being

Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111, Visits: 263

The function is oreplace, not replace.

It is only available if you have set up the Oracle UDF's, available from the Teradata website. (And you have access to them!)
If you want to strip off linefeed and tab, it it oreplace(oreplace('0A'XC,' '),'09'XC,' ')

The functions are available in SQL, TPump and Mload. You cannot use them directly in Fastload - load the data as is and then clean it up if you are using Fastload.

Post #16916

anil4yesu

Posted 9/23/2009 6:29:13 PM

Forum Newbie

Group: Forum Members
Last Login: 9/23/2009 6:27:09 PM
Posts: 3, Visits: 18

Thanks, appreciate your help, I downloaded the Oracle UDFs but I am trying to get permissions to install it.

Post #16918

« Prev Topic | Next Topic »

Reading This Topic

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 6:20pm