Export Properties: Text

The table below describes the properties that can be specified for exports to text.

Property	Description
Table	The name of the selected table to be exported.
Export Type	The file type to which your export will be saved.
Export File System	This field describes the file system to which your table will be exported. Local or mounted disk Amazon S3 Azure Data Lake Storage Gen2 Azure Blob Storage Oracle Cloud Infrastructure Google Cloud Storage Note: Credentials for cloud-based storage systems can be specified in the Server section of The Application Default Settings.
Export Location	This setting describes where the export file will be saved and what its name will be. Enter the path and name of the export file. You can embed macros (of the form &[macro]) in the file name.
File Extension	This setting specifies the file extension for the export file.
When File Exists	This setting specifies what Data Prep Studio should do if a file with the same name exists in the folder you specified in the Export Location field. Select an action if the export file already exists: Overwrite the file Append records to the existing file Skip the export operation
Encoding Type	This setting specifies which encoding type to apply to the export file. At present, the encoding types Code Page, UTF-8, UTF-16LE, and UTF-16BE are accepted.
Code Page	When the encoding type selected is Code Page, this setting specifies which code page to apply to the export file.
Append DOS end-of-life character (x1A)	This option determines whether or not a DOS end-of-file character (x1A) is appended to the end of the file. This option is provided to enable compatibility with systems that expect the data in this format. This end-of-file character is often known as Control-z.
Insert page breaks	This setting specifies whether to add page breaks to a file at regular intervals. Before first and between pages Never Between pages only
Automatically Select All Reports	If the table to be exported is created from several reports, this setting instructs the application to include all reports associated with the table in the export file. It is applicable only to report exports.
Select Reports	When Automatically Select All Reports is deselected, this setting specifies which of the reports that make up the table should be included in the export file. It is applicable only to report exports.

Intellectual Property Rights Notice | Technical Support