HP 95LX - Page 86

If you’re using a delimited text file:
4.
5.
86
“Print” the Phone book records to a text file (de 1 imprt «1 xt): Press (MENU,
(Print, (Flile, (AJL, Chard, type del imprt and press ENTER).
Move to the Memo Editor, save any currently open files, then open the
delimprt .t xt file you just created, and prepare and delimit the text:
— 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. Notice that you
can change the number of items in a record by delimiting the text file (Phone
Book only has three fields per record).
— Put quotation marks around each item except the birthdate ( they're label
data). Insert a comma between each item within a record.
— Make sure there are no extra spaces between items (there are quite a few
between the name and phone number in the original file). When you've
finished, the file should look something like this:
(Memo 99-30-91 12:52 pm)
DEL IMPRT . TXT Ins Linei1 Colfil
yyy
"Fronmeyerhof" "Jessica" "583" ," 9555-08117
S
Holoate®, » "Portland" "OR" "97206" 12-17-35
"Johnson" , "George" 1213" , "555-6790" ; "455
N jodun a Ave.", San
Monica" a nCA" iS ade RE 89-624
“Tore? Abrahan® 171475 855-5068" , "78
Gardner" , s"Claremont" "CR" "91711" ,84/86~
Paste Pabrk
EB Find Mark J,
. Resave the file, ugly as it is: Press (MENU), (Flile, (Slave, ENTER), (Y).
. Open a 1-2-3 worksheet and move the cursor to the cell that is to be the upper-
left-hand corner of the imported data.
. Press (MENU), (Flile, (Jmport, (Numbers, type the complete pathname of the
delimited text file (C* “dat. “del imprt .t xt in this case); press ENTER).
. Inspect the newlyimported cells. You should see 3 rows and 11 columns of data.
The birthdate did not end up in one cell, but three cells (month, day, year)—
because the slash marks in the date format were interpreted by 1-2-3 as
delimiters between the numbers. In fact, just about any character other than
anumeral will act as a delimiter in the middle of a string of numbers when you
use the Import Numbers (delimited file) option.
3. SHARING INFORMATION BETWEEN APPLICATIONS