644
SP.FREAD
(f)
When data is read after CSV format conversion and the designated number of columns is other than 0, the data is
read as the table with designated number of columns in CSV format file. The elements outside of the designated
columns are ignored.
When data is read after CSV format conversion and the designated No. of columns is other than "0":
Example
Data
created
by
E
XC
EL
Data
sa
v
ed
i
n
the
CSV
format
Ma
i
n
/
sub
i
tem
,
,
Measured
v
a
l
ue CR
LF
L
ength
,
1 ,
3 CR
LF
LF
T
emperature ,
-
21
, CR
LF
LF
Contro
l
data
Data
to
be
read
i
nto
de
vi
ces
SP
.F
R
E
AD
D10
K
2
U
0
D20 D99 M0
Data
that
w
as
read
Fil
e
name
Contro
l
data
H
0100
D10
D11
D12
D13
D1
4
D15
D16
D17
D20
D21
D22
D099
D100
D101
D102
D103
D10
4
D105
-
K
6
-
K
0
K
0
K
2
K
0
H4
2
4
1
H444
3
H
0000
K
6
K
0
K
0
K
0
K
1
K
0
K-
21
E
xecut
i
on
/
comp
l
et
i
on
type
N
ot
used
N
o
.
of
request
read
data
N
o
.
of
co
l
umns
des
i
gnat
i
on
Data
type
spec
i
f
i
cat
i
on
Fil
e
name
"
ABCD
"
N
ot
used
Read
data
El
ements
outs
i
de
the
des
i
gnated
number
of
co
l
umns
are
i
gnored
.
1
T
emperature
-
21
Ma
i
n
/
sub
i
tem
Data
bet
w
een
,
and
,
L
ength
L
oaded
data
Stores
the
number
of
read
data
Read
i
ng
resu
l
t
(
N
o
.
of
read
data)
S
i
nce
" -
21
" i
s
a
numer
i
c
v
a
l
ue,
i
t
i
s
con
v
erted
to
a
b
i
nary
v
a
l
ue
.
S
i
nce
"
1
" i
s
a
numer
i
c
v
a
l
ue,
i
t
i
s
con
v
erted
to
a
b
i
nary
v
a
l
ue
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
" " i
s
nonnumer
i
c
data
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
"L
ength
" i
s
nonnumer
i
c
data
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
"T
emperature
" i
s
nonnumer
i
c
data
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
"
Ma
i
n
/
sub
i
tem
" i
s
nonnumer
i
c
data
.
Fil
e
pos
i
t
i
on
Ma
i
n
/
sub
i
tem
Measured
v
a
l
ue
L
ength
T
emperature