DataFlux Data Management Studio 2.6: User Guide
You can add a Fixed Width Input node to a data job. Then, you can perform the following tasks:
You should examine the structure and content of the fixed-width file in a text editor. Be sure to note features such as whether the first line contains headings, the length of the longest records, and which encoding is used.
Use the data that you gathered when you reviewed the text file to configure its parameters in the Text File Input Properties dialog. For example, the following display shows the parameter configuration for a fixed-width file that uses the system default encoding.
You will establish the record length when you define the column widths.
You can begin the column-definition process by clicking Advanced. You will see a calculated record length in the Record Length dialog because you kept the default record length of 0 in the configuration task. Click OK to accept the calculation and access the Column Selection dialog, as shown in the following display.
Note that the first and second column markers have been created by clicking on the appropriate positions on the ruler above the list of rows. The following display shows the columns after they have been named and identified by type.
You can make any needed changes to the field names, field types, start positions, and field lengths in the fixed-width file directly in the Fields section of the dialog. Then, you can click OK to save the properties for the file.
You can easily preview the text file that you added to the data job. Right-click the Text File Input node and click Preview in the pop-up menu. A preview is provided in the Details pane, as shown in the following display.
Documentation Feedback: yourturn@sas.com
|
Doc ID: dfU_T_InputFixedWidth.html |