Re: remove the CRLF in the fastexport generated file

Tools
Enthusiast

Re: remove the CRLF in the fastexport generated file

Hi,

I need to export file with certain fields. Where one of coulmn data has a CR.

For eg:

              cml4

 record1 aaa      bbb       ccc

 record2 ddd      eee       ffff 

The spaces between the aaa bbb represents the New Line Char..

Now i need to remove this and need to export the field. That export file should not contain CR.

please Help me!!

4 REPLIES
Enthusiast

Re: Re: remove the CRLF in the fastexport generated file

The Record may or may not contain CR. If it has don't how many CR it will be..

Senior Apprentice

Re: Re: remove the CRLF in the fastexport generated file

This should be done using a UDF, check if oTranslate or oReplace is installed on your system, if not you should tell your DBA to do it :-)

Dieter

Enthusiast

Re: Re: remove the CRLF in the fastexport generated file

Hi Dnoeth,

Thanks for replying..

I dont have an option to use OReplace or OTranslate.. Is there any other way i can get out from it..

Thanks

balu

Teradata Employee

Re: Re: remove the CRLF in the fastexport generated file

Balu,

You can write an outmod to validate and preprocess export data records from Teradata Database before writing them to files on the client system.

Thomas