Text File Schemes- Loading ASCII Text Files

Text File Schemes allow you to load data from ASCII files into the Geographic Calculator.  There are three types of common text file schemes included with the Calculator: .CSV .TSV and .SEG.  These schemes can be used as they are, or modified to meet the needs of a particular file.  The Text File Schemes dialog box allows you to add, edit, and delete custom text file schemes.

More:

Create a new text file scheme

How to change an existing text file scheme

How to delete an existing text file scheme

Create a New Text File Scheme

1. Go to Options>Text File Schemes

2. In the drop down menu at the top, enter the three letter extension of the file type you are creating a scheme for, click the Add button.

3. Enter a description for the text file scheme (optional). This description will be displayed in the file open and save dialog filters (drop down box).

4. Select the text file type, either Delimited Text or Fixed Length Fields from the File Type group box. When you make a selection, the appropriate dialog box (described below) will display:

• For Delimited Text files, select the delimiter and specify the text qualifier from the Field Delimiters group box. The delimiter is the character that separates fields. The text qualifier encloses text strings.

• For Fixed Length Fields files, enter the number of fields (columns), the width of each field, and the output field alignment (justification).

7. Specify header record information from the Header Records group box. NOTE: The Geographic Calculator assumes that headers come BEFORE all data.

There are three options:

Total number of header records

Records above first blank line(s)...

Header records begin with ...

8. Specify a setting in the Field Names area. The settings determine how the grid columns are named.

There are three options:

Use Default Field Names (default)

Last Header Record Contains Field Names

First Non-Header Record Contains Field Names

9. Specify a setting for the Data Records. This setting specifies when the Calculator should start reading data.

There are two options:

Data Records Start After the Header

Data Records Begin With

10. Click OK to save the scheme.

How to change an existing text file scheme

1. Select Text File Schemes... within the Options Menu.

2. Select the scheme from the Unique File Extension list.

3. Change any required parameter.

4. Press the OK button.

How to delete an existing text file scheme

1. Select Text File Schemes... within the Options Menu.

2. Select the scheme from the Unique File Extension list.

3. Press the Delete button.