HP 95LX - Page 85

Each group of X's represents an individual data item. Each column represents the
same kind of data. Each column begins at the same place and, although item
lengths can vary within a column, no column interferes with its neighbor.
Carriage Returns and Tabs
You either delimit or columnize a text file—not both—but in either case, before you
import from a text file, be sure to:
* Replace all tabs with an appropriate number of spaces. This is usually only a
concern in columnized files. Tabs can result in unpredictable spacing during
an import, messing up an otherwise well-planned effort.
¢ Eliminate all carriage returns (represented in Memo Editor by the character
+) except those at the end of each record.
Transferring Data from the Phone Book
They demonstrate how you might transfer data from the Phone Book (a kind of
database, after all) into a 1-2-3 spreadsheet. The basic procedures shown below
work for any application that can create a ASCII text file of its data. Create a short
phone book file, with the following three records:
Johnson, George Fronmeyerhof, Jessica Toff, Abraham
(213) 555-6790 (503) 555-0117 (714) 555-5068
455 NW Tujunga Ave, 3922 SE Holgate 78 E. Gardner
Santa Monica, CA 90405 Portland, OR 97206 Claremont, CA 91711
06/09/62 12/17/57 04/06/48
1. Open the Phone Book application and save any currently open phone book file
(MENU), (File, (Slave, (ENTER), (Y)es). Then press (MENU), (Flile, (NJew to begin a new
Phone Book.
2. Press (IINE=TMA) and enter George Johnson's data; press (IINE=mA)
and enter Jessica Fronmeyerhof’s data; press (F8)( )and enter Abraham
Toff’s data.
3. Press (EEE), then (MENU), (Flile, (Slave, type Imprt, and press to
save the new Phone Book as IMPRT .PBK.
(cont.)
Importing Data into a 1-2-3 Spreadsheet 85