16.20 - File Format Types - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty

When saving an Answerset tab, spreadsheet data is saved using one of the following file types. Text data is saved using one of the file types described under Saving a Query.

File Type Description
Tab delimited [ANSI] Any special formatting applied to the Answerset is not saved, but it can be read into a spreadsheet or a text editor for formatting. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Tab Delimited [Unicode] Any special formatting applied to the Answerset is not saved, but it can be read into a spreadsheet or a text editor for formatting. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Tab delimited [UTF-8] Any special formatting applied to the Answerset is not saved, but it can be read into a spreadsheet or a text editor for formatting. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Delimited Text [ANSI]

To set the use of quotes or to set the delimiter between columns, see Setting Export/Import Options.

If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.

Delimited Text [Unicode] If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Delimited Text [UTF-8] If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. The column headings are saved only if they are visible on the screen.
Microsoft Excel 2003

If there are multiple tabs in the Answerset window, you are asked whether you want to save all tabs to a single ExcelWorkbook.

Any special formatting applied to the Answerset is retained. The entire Answerset is saved. Column and row headers are saved if they are currently visible.

Microsoft Excel 2007

If there are multiple tabs in the Answerset window, you are asked whether you want to save all tabs to a single ExcelWorkbook.

Any special formatting applied to the Answerset is retained. The entire Answerset is saved. Column and row headers are saved if they are currently visible.

PDF Document [*.pdf] Any special formatting applied to the Answerset is retained. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved.
Web Page [*htm] Any special formatting applied to the Answerset is retained. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved.
Hidden columns are not saved if you save as HTML.
XML Document No special formatting is retained. If a block of cells is selected, only that block is saved. If no part of the spreadsheet is selected, the entire Answerset is saved. See Saving as XML.