Creating a Fixed Format That Uses Carriage Returns

A fixed-format data file often includes a carriage return (new line) at the end of each record, such as the data file in Figure 55.

20 chars          20 chars          15 chars       2 chars

John Brown        100 Main St.      Citadel        LA
Mary Smith        3141 Temple Way   Chesapeake     AZ
Larry Little      44 Elm Rd. #6     Boston         MA

When you prepare the format for this data file, you must include a dummy field for the carriage return. When you create the load map for this format (see Creating a Load Map), do not link the dummy field to a database column. Figure 56 shows the format for the data file illustrated in Figure 55.

Figure 56. Fixed Format with Dummy Entry for Carriage Return