DataFlux Data Management Studio 2.6: User Guide
You can use the Fixed Width File Information dialog to select a delimited file and prepare it for inclusion in a profiling run. The dialog contains the following elements:
Input file name - Enables you to specify the path and name of your text file data source (for example, c:\myinput.txt), or click Browse to navigate to the file.
Record length - Enables you to specify the number of characters in the line that contains each record.
Number of rows to skip - When selected, specifies the number of lines to skip before the file content is read as data. Check this box if your text file has introductory or header information at the top.
Encoding - Enables you to specify the type of encoding used. Click the drop-down list for encoding options.
Number of rows to read - Sets a limit to the number of rows that can be retrieved.
Truncate record at line terminator - When selected, enables you to handle exceptions that do not follow the specified fixed length for a row.
The Fields section of the properties dialog includes the following elements:
Fields Table - Enables you to define each field in your text file, including Field Name, Field Type, Start Position, and Field Length. You can click Add to define a new field and use the up and down arrows to change the order of fields. Finally, you can click Delete to remove field definitions.
Import - Enables you to restore a file layout from a DFL file that you have exported.
Export - Enables you to store a given file layout that can be shared for parsing other input files. In this case you can set the text qualifier and the delimiter and store the file layout to create. The Export option lets you save the file layout as a DFL file.
Advanced - Displays the Column Selection dialog. This dialog enables you to set the demarcations for field lengths, permits interactive sizing of input fields. The dialog contains the following fields:
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfU_Profile_Fixed_Info.html |