Archives of the TeradataForum

Message Posted: Tue, 09 Aug 2005 @ 12:50:33 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You're dealing with the "built in functionality of excel". There's no "formatting comments" that can be embedded into a CSV file that I know of. If you wrote a little middleware script/app/utility, you could take the BTEQ output and stream it into an excel object with the desired formatting, or even try to output to HTML and write the HTML out as a .XLS which will open and display properly in Excel. Or perhaps there's a default setting in Excel you can set, but that would be for your particular installation only, and wouldn't transfer to others.

You can output the following string to your CSV:

     ="371234567891234567",column2, column3
     ="371234567891234568",column2, column3
     ="371234567891234569",column2, column3

It should display as you wish it to in Excel, but will provide you some "opportunities" if you try to utilize the data in formulas, etc.

Alistair MacGowan
Senior Database Administrator

	<Prev	Next>		<<First	<Prev	Next>	Last>>