Pipe delimited fast export file

General
Fan

Pipe delimited fast export file

Hi,

I am exporting a large amount of data into a file.The specification is like each column should be seperated by pipe.If there is no data,there should be space.(| |)

I need file in this format

if there is data it should be like this

1|XXX|1234|FFFF|X1AB5 -  no leading or trailing spaces should be there between the pipe and the data.

If there is no data it should be like this

1| |1234| |X1AB5 - space shoud be there only if there is no data.

No two pipes should come together(||)

I have more than 60 columns in my table.Do i need to give case for each field or is there any other easy option?

I am new to teradata.Kindly advice.Thanks in advance.

1 REPLY
Enthusiast

Re: Pipe delimited fast export file

Hi,

You can do it.However, I see that many experts here have recommended using tpt.

This link can help you>

http://forums.teradata.com/forum/database/mode-and-format-td-utilities.

Cheers,