Identifying records and fields in your data
Depending on the source of the data that you are importing, the process of identifying record and field specific data is different. To successfully import data, you must ensure that the characters used to separate records and the fields that are contained are identified.
- In the File Name, specify the file path and name for the file that contains your data.
- To determine where to start the import, specify the record to start the import from, and whether the first record is a list of the field names.
- Select the characteristics of the text:
Option Description Text Qualifier The Character to use tpo identify the start of the data to import. Auto Trim Trailing Spaces in Data Removes any spaces at the end of a field value. Record Delimiter The character that is used to split the data into separate records. Field Delimiter The character that is used to split the data in a record into different fields. Dates, Times & Numbers The formats used to store different numerical values within the data.