Defining Delimited File Formats with a Single Format

From the JD Edwards EnterpriseOne Table Conversion director, access the Select Input form or the Select Outputs form.

1. Select User Defined Format, and then click Define Format(s).

2. On the User Defined Format - Type form, select the Delimited - Characters such as commas or tabs separate each column option.

3. Select the Single Format - All rows have the same format option, and click Next.

4. On the User Defined Format - Column Delimiter form, select the delimiter that separates the columns in the file:

   • Tab

   • Comma

   • Semicolon

   • Space

   • Other

5. Select the textual qualifier that is used to enclose a string of text:

   • None

     Select this option if no character is used to qualify text in this user-defined file.

   • Single Quotations

     Select this option if a single quotation mark is used to qualify text in this user-defined file.

   • Double Quotations

     Select this option if a double quotation mark is used to qualify text in this user-defined file.

6. If the user-defined format incudes column headings in the first row, select The first row contains column headers, and click Next.

7. On the User Defined Format - Column Layout form, select a format from the list of available formats.

   You define the columns for the format so that the system can parse the information from the file.

8. For each column, click Add to define the column.

9. On the New Column Properties form, modify these fields as required, and click OK.

   • Name

   • Length

   • Type

10. To edit an existing column, select it, click Edit, and modify the properties on the Column Properties form.

11. To model the columns after an existing table, business view, or foreign table, click Model, select the appropriate tab, and then select the table or business view that you want to use as a model for the user-defined format.

    Note: You cannot model the columns after an existing object unless the layout of the two objects match.

12. Click OK, and then click Next.

    The system copies the format from the model that you selected and places it into the column layout grid.

13. On the User Defined Format - Finish form, click Finish.