beautypg.com

Pitney Bowes MapMarker USA User Manual

Page 68

background image

Opening a Table or Text File

MapMarker USA 25

68

User Guide

The following steps follow one likely scenario and show how to use the Text File Wizard for a
comma-delimited text file This example assumes that you are opening the file for the first time and
the first row of the table is used for column titles (rather than data).

First, open the text file as described in

Opening a Table or Text File on page 66

. Select TXT file

extension from the Files of type drop-down.

1. Step 1 of the Text File Wizard displays the Input Table dialog with the name of the file that was

previously opened. The list box area of the dialog will display up to the first 20 records of the
opened file.

Text File Type: If the text file is a delimited file, the appropriate button will be selected in the wizard.

Delimiter Type: If the delimiter is recognized it will be selected and the other choices are disabled.

For example, with a CSV file a comma delimiter is recognized and the other group selections are
disabled. Semicolon, tab, or slash can also be used as delimiters. If one of these standard
delimiters is not recognized in your text file, you can select Other and type the delimiter
character. For example, your text file might use a pipe symbol (|) as a delimiter. Not all
characters and symbols can be used as delimiters. You will receive an appropriate message if
you try to specify a disallowed character.