643
SP.FREAD
1
2
3
4
4
6
7
8
7.18
Ot
her inst
ructions
7.18.1
3
SP.FREAD
If the number of columns varies in each row, the data is also read by ignoring the rows.
Such file cannot be created using EXCEL. This happens when CSV file is modified by a user.
If the number of columns varies in each row when the data is read:
Example
-
21
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
Contro
l
data
H
0100
D10
D11
D12
D13
D1
4
D15
D16
D17
D20
D21
D22
D099
D100
D101
D106
-
K
7
-
K
0
K
0
K
0
K
0
H4
2
4
1
H444
3
H
0000
K
7
K
0
K
0
K
0
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
Ma
i
n
/
sub
i
tem
Data
bet
w
een
,
and
,
Read
data
Ma
i
n
/
sub
i
tem
,
,
Measured
v
a
l
ue
E
xcess CR
LF
L
ength
CR
LF
T
emperature ,
-
21
, CR
LF
,
K
0
K
0
T
emperature
D105
D103
Measured
v
a
l
ue
D102
L
ength
D10
4
E
xcess
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
.
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
"E
xcess
" i
s
nonnumer
i
c
data
.
Con
v
ers
i
on
data
(0)
i
s
stored
s
i
nce
"
Measured
v
a
l
ue
" 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