All Forums General
Aishu 4 posts Joined 03/13
13 Feb 2014
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.

Raja_KT 1246 posts Joined 07/09
13 Feb 2014

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,

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.