HP 95LX - Page 87

If you’re using a columnized text file
4. Openthe i1mptt .pPbkK file from the Phone Book, if its not already open (see
page 85 for how it was created).
5. “Print” the Phone Book records to a text file (1mPrt . txt): Press (MENU,
(Print, (Flile, AL, (Chard, type 1MpPt~t and press ENTER).
6. Move to the Memo Editor, save any currently open files, and then open the
imprt .t xt file that you just created, to prepare and columnize the file:
— Eliminate all carriage returns (*) except those between records.
— Decide how many data items you want to include with each record. Use the
following: Last name, first name, area code, phone number, address, city,
state, zip code, birthdate. Each record will have nine items and thus, you
will have nine “columns” in the file.
— Eliminate any commas that you don’t want to see in the spreadsheet —such
as the one between last and first names and the one between city and state.
— Using spaces only, adjust each data item so that it lines up with the
corresponding data items in the other records. All last names should line
up under each other, all first names should line up under each other, and
so forth. When you've finished, the file should look something like this:
(Memo 99-30-91 12:52 pm)
IMPRT .TXT* Ins Line:l Col:1
rrr
Fronme erhof Jessica 3583 355-8117
SE Ho ate Portland OR
Geo 1001 93k
nnson egrge - Ca 213 5355-6798
2 HW Tujunga Ave. Santa Monica CH
> 6/89/624
Abraham__714 355-5868
dn ner Claremont CA
TINY
Mn
a
FE
E
i
a
« Ga
vil B
Hel ) Find i i. :
[=] - 0 ~-.-
\. = Pen = 1 J,
Notice that the small size of the HP 95LX screen causes you to make some
mental adjustments when it comes to aligning “columns.” Each record
wraps into three lines. The first line has four columns, the second has three
and the last one has two columns. The consistency of columnized text can
be seen in the fact that the city, for example, is always in the second column
of the second line of each record (and these columns line up with each other).
It doesn’t really matter that there are other intervening lines in the display
because, in terms of data items and records, they're not really “in the way.”
Importing Data into a 1-2-3 Spreadsheet 87