Open topic with navigation
Text File Format
To customize data fields and their output in a text-based format used in exporting or importing.
Note: The actual title of this dialog may differ depending on formats used in exporting / importing. The availability of customization options depends on the used format specifications.
- From the Delimiter field, select a symbol to be used as a data delimiter in data records between data fields. Choose from space, comma, tabulation symbols or select other and use the drop-down list with more symbols available.
- Check the Header in first row box to:
- For data export: add the header to an exported file according to the File Style settings.
-
For data import: parse the first line in an importing file as a header. If the header has been parsed successfully, the file will load according to this header. Otherwise, the first line will be skipped and the file will load according to the File Style settings.
-
From the File Style field, configure the data fields to be exported / imported and define their order in a data record.
- Select a file style for the chosen format from the File Style drop-down list. By default, MAGNET Field offers predefined style(s) for each supported text-based format.
- Click the Edit button to open the Custom Style dialog and modify the file style currently displayed in the File Style drop-down list.
- Click the Add button to open the Custom Style dialog and create a new file style and add it in the File Style drop-down list.
- Click the Delete button to delete the file style currently displayed in the File Style drop-down list. A confirmation prompt will display to prevent accidental deletion.
- Click the Preview button to open the File Preview dialog showing the first few lines of the selected external file as a raw text preview to check the file format and the presence of data fields, their order, and used delimiter.
- Click Next to apply the selected data content and data representation and proceed with export / import configuration. Click
to apply the selected data fields and their output order and proceed with target data generation.
- Click Back to return to the previous dialog. Click
to close the dialog and return to the Exchange Menu.
Open topic with navigation