Cloud Data Integration All Products
Name of the fixed-width file format.
Location of the fixed-width file format. Browse to the folder where you want to store the fixed-width file format or use the default location.
Explorepage is currently active and a project or folder is selected, the default location for the asset is the selected project or folder. Otherwise, the default location is the location of the most recently saved asset.
Description of the fixed-width file format.
Sample Flat File Connection
Connection to the sample file that you use to specify the fixed-width format.
Sample file that you use to specify the format options.
Ends each row with a newline character. Must be enabled when you use a fixed-width file format for a flat file source or target object. Line sequential is enabled by default.
Number of rows to skip
Number of initial rows to skip. For example, you might want to skip blank rows or header rows.
Number of bytes to skip after column ending
Number of bytes between the last column of one row and the first column of the next.
Null character type
Whether the null character is text or ASCII.
Character to represent a null value.
Repeat null character
Reads repeat null characters in a single field as a single null value.
Strip trailing blanks
Removes trailing blanks from string values.
Default Date Format
Date format to use for the column when a date format is not specified in the flat file connection. To specify the default date format, enter the following information:
For example, if you want the format to be fixed width with a width of 12 bytes and date format of DD/MM/YYYY, enter the following text:
F 12 DD/MM/YYYY