Export Properties: Fixed Text

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

Property	Description
GENERAL PROPERTIES
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 extension to use for the export file. It is enabled only when the Filter setting is set to "All Filters."
Filter	This setting specifies which filter, if any exist, to apply to the table when it is exported. When All Filters is selected as a filter option, exports will automatically be named according to the file name.
Sort	This setting specifies which sort, if any exist, to apply to the table when it is exported.
Include Column Headers	Selecting this setting instructs Data Prep Studio to include the column header in the export file. This header will become the first line in 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.
Pad each field with X extra spaces	Use this setting to separate exported fields with an extra space when exporting to a fixed text file. With this option unselected, field values might "bump up" against each other producing, for example, "123.45CD" rather than "123.45 CD".
Pad generically formatted numeric fields with zeros, suppress the decimal point, and use trailing negation	Use this setting to export numeric fields using a standardized format that pads each value with leading zeros, removes the decimal point and places the negation sign at the end of the field value. This format represents the number "-123.45" as "00012345-". When selected, this option reformats each numeric field whose type is set to "Numeric" (as opposed to Thousands, Currency, or Percentage), removing the decimal character, and then padding the field with sufficient leading and trailing zeros to match the field’s column format, preserving the rightmost character position for a trailing negation sign.
Insert a page break after n lines	Use this setting to add page breaks to a file at regular intervals by specifying the number of lines you want on each page.
Repeat field names on each page	Exports the Table view field names to each page when exporting data to a fixed-width text file with pagination enabled. This setting can be enabled only when the settings Include Column Headers and Insert a page break after n fields are selected.
Default decimal precision when not supplied by column format	The value selected refers to the number of decimal places of accuracy. It is applied when the format string does not indicate decimal precision.
Legacy compatibility mode - For numeric and date columns, override Data Prep Studio conversion locale settings with system defaults	Enabling this option will cause column format customizations to be ignored during the export of numeric and date columns in favor of the system defaults.
Export All Rows/Limited Rows	For tables with defined row limits, this setting specifies whether the defined row limits should be respected during export. Select the appropriate checkbox to instruct Data Prep Studio to export all rows or only those rows that fall within the limit you have set.
SUMMARY-SPECIFIC SETTINGS
Summary	If the table to be exported is a summary, this setting specifies which summary to include in the export. When All Filters is selected as a Filter option, you will be unable to select All Summaries as a Summary option. You can select All Summaries as a Summary option by deselecting All Filters as a Filter option and selecting No Filter instead.
Measure	This setting specifies which measure should be applied to the exported summary. It is enabled when only a column key is defined in the summary.
Split	This setting instructs the application to create a separate file or table when a distinct value of the first key is encountered in a summary.
Drill Level	Specifies the drill level to apply to the exported summary. A higher drill level indicates more columns displayed in the output table.

Intellectual Property Rights Notice | Technical Support