EasyManua.ls Logo

HP 95LX - Page 88

HP 95LX
164 pages
Save Page as PDF
Print Icon
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
88
Resave
the
file
(MENU),
(Flile,
(Slave,
ENTER),
(Y)),
and
open
a
1-2-3
worksheet
and
move
the
cursor
to
an
area
with
plenty
of
room.
Leave
the
cursor
in
the
cell
that
you
want
to
be
the
upper-left-hand
corner
of
the
imported
data.
Press
(MENU),
(File,
(Jmport,
(Tlext,
type
the
complete
pathname
of
the
text
file
being
imported
(C3
S—dat.~imprt
.t
xt
in
this
case),
and
press
ENTER).
.
Inspect
and
adjust
the
import.
You've
actually
imported
data
into
just
three
cells
(three
rows,
one
column).
Each
cell
contains
one
record—all
the
informa-
tion
in
one
long
string
of
text
characters,
so
parse
the
data
into
separate
cells:
Move
the cursor
to
the
upper-left-hand
cell
of
the
imported
data
that
you
wish
to
parse.
Press
(MENU),
(Dlata,
(Plarse.
You
will
see
a
prompt-box
displayed,
showing
an
input
column
and
an
output
range.
Ignore
it
for
now.
Press(Flormat-Line,
(Create.
Lotus
created
and
inserted
a
format-linein
the
cell,
shifting
the
imported
data
down
a
row
in
the
process.
Examine
the
format-line.
1-2-3
has
looked
at
the
first
data
entry
and
decided
how
to
break
the
long
string
into
separate
data
items.
Each
letter
that
you
see in
the
format-line
represents
the
beginning
of
a
new
data
item—as
1-2-3
interpreted
it.
These
five
letters
each
stand
for
a
data
type:
D
indicates
the
beginning
of
a
date
item.
L
indicates
the
beginning
of
a
label
item.
S
indicates
the
beginning
of
an
item
you
wish
to
be
skipped.
T
indicates
the
beginning
of
a
time
item.
¥
indicates
the
beginning
of
a
value
item.
You'll
also
see
some
*
and
¥
characters.
A
*
is
a
placeholder
for
a
character
in
a
data
item.
A
¥
is
a
placeholder
for
a
space
that
might
turn
into
a
character
in
a data
item
if
one
of
the
records
needs
more
room
for
that
item.
Edit
the
format-line.
Press
(Flormat-Line,([E)it.
You'll
see
the
cursor
at
the
beginning
of
the
format-line.
You're
in
overwrite
mode
so
that
you
only
need
to
move
the
cursor
to
an
error
and
type the
correction.
Make
the
following
corrections
and
press
(ENTER)
when
you're
done:
Change
the
Y
over the
area
code
to L.
Change
the
Y
over
the
beginning
of
the
address
to L.
Change
the
*¥L
combinations
over
the
address
to
*
>.
Change
the
Y
over
the
zip
code
to
L.
Press
(nput-Column,
and
type
in
the
range
(example:
383.
.a88)
that
includes
the
imported
data
and
the
format-line.
Remember
that,
despite
appearances
to
the
contrary,
it
occupies
only
one
column.
Press
(OJutput-Range,
and
move
the
cursor
to
the
upper
left-hand
cell
in
the
range
where
you
want
the
parsed
data
to
go.
Make
sure
to
allow
adequate
number
of
columns
and
rows,
so
that
you
don’t
overwrite
pre-existing
data.
Press
(Glo
to
execute
the
parse.
You
may
need
to
adjust
the
column
width
in
some
cells
to
see
all
of
the
data.
3.
SHARING
INFORMATION
BETWEEN
APPLICATIONS

Table of Contents

Related product manuals