InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 15:18:13 GMT20http://www.teradata.com/teradataforum/Topic15901-10-1.aspxYou cannot do it if you are exporting a DATA file.If you can do an EXPORT REPORT, you can:.SEPARATOR '|'(or whatever separator you want.)If you do this, everything will come out as characters, you must suppress pagelength/ headings and column headings (you can only do this in your SQL), and the maximum line length is 265 characters.Thu, 25 Jun 2009 11:36:01 GMTjimmhttp://www.teradata.com/teradataforum/Topic15901-10-1.aspxTake a look at the Linux/Unix 'sed' command.HTH.Cheers.Carlos.Thu, 25 Jun 2009 10:20:57 GMTCarlosALhttp://www.teradata.com/teradataforum/Topic15901-10-1.aspxHi Guys,I am using an export command in a BTEQ script. The output file needs to be formatted to get the a comma, pipe(|) or ~ delimited file. Can you guys please help me in this regard? The SQL Statement that I am passing to do this Export command is dynamic, hence can not be pre appended with any of the delimiters. The Code snippet would look like this.EXPORT DATA FILE=$TABLE_NAME.txt/**************************************************************************************************Run the select statement in the file created by shell script**************************************************************************************************/. run file $COL_FILE_NAMEContent of the $COL_FILE_NAME is something that would change dynamically during executionThu, 25 Jun 2009 05:16:19 GMTprajithvarreir