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 EXCEL
Data saved in the CSV format
Main / sub item , , Measured value CR LF
Length
,1,3CRLFLF
Temperature
, -21 , CR LFLF
Control data
Data
to be read into devices
SP.FREAD
D10
K2U0 D20 D99
M0
Data that was read
File name
Control data
H0100D10
D11
D12
D13
D14
D15
D16
D17
D20
D21
D22
D099
D100
D101
D102
D103
D104
D105
-
K
6
-
K
0
K0
K2
K0
H4241
H4443
H0000
K6
K0
K0
K0
K1
K0
K-21
Execution/completion type
Not used
No. of request read data
No. of columns designation
Data type specification
File name
"ABCD"
Not used
Read
data
Elements outside the designated
number of columns are ignored.
1
Temperature
-21
Main/sub item
Data between , and ,
Length
Loaded data
Stores the number of read data
Reading result (No. of read data)
Since " -21 " is a numeric value, it is converted to a binary value.
Since " 1 " is a numeric value, it is converted to a
binary value.
Conversion data (0) is stored since " " is nonnumeric data.
Conversion data (0) is stored since "Length" is nonnumeric data.
Conversion data (0) is stored since "Temperature" is nonnumeric data.
Conversion data (0) i
s stored since "Main/sub item" is nonnumeric data.
File position
Main / sub item
Measured value
Length
Temperature