Delimited file guidelines – Pitney Bowes MapMarker USA User Manual
Page 70
Opening a Table or Text File
MapMarker USA 25
70
User Guide
By default, the output file is created the same folder that contains the input file. If this folder is not
writable, the output file is created in the My Documents\MapMarker USA\ folder. If the output file
already exists, you can choose to overwrite or change the file name.
4. Click OK.
5. Select the input columns from your table. See
Selecting Input Columns on page 74
.
6. Select output columns. Standard address column names will be named with the OUT_ prefix (for
example, OUT_STATE and OUT_ZIPCODE) and these column names will be pre-populated in
output column selections. See
Selecting Output Columns on page 75
.
Delimited File Guidelines
The Text File Wizard helps you manage how delimited files are interpreted and used in MapMarker.
The following guidelines may help you when using the Text File Wizard.
•
If you want to ignore the first row in the text file (that is, not use it for either column title or data),
you should remove the row from the data file. When you geocode, you can specify which rows to
geocode, so you can select or skip row 1. See
of
Geocoding Your Table Automatically
for an example of selecting a range of rows to geocode.
•
Delimited text files can be geocoded automatically or interactively. See
Geocoding Your Table Interactively on page 79
.