37
CHAPTER 3 SPECIFICATIONS
3
3.3 CSV File Output Format
3.3.2 Output details of lines and columns
(5) Data line
Sampled data values are displayed. One line contains the data sampled at one time.
*1 At the first sampling, "0" is stored.
*2 When the upper limit of the display range is exceeded, the value returns to 1, and the time interval measured again is
output.
*3 If any data are missed to be sampled, the index value is reset to 1.
*4 When the maximum value is exceeded, it returns to 1 and is incremented again.
*5 Characters other than ASCII and Shift-JIS code characters, double quotation marks (" "), commas (,), and semicolons (;)
are replaced with periods (.).
*6 If the sampling coincides with a system operation (such as a system interrupt), "0" is output.
*7 If the sampling coincides with a system operation (such as a system interrupt), "* SYSTEM" is output.
*8 When the value to be output is outside the range of -2147483648.0 to 4294967295.0, it is displayed in the format
equivalent to "exponential representation and 9 fractional digits".
*9 The size of the Data line is the total of the following.
When logging 128-point data in D100 to D227 in the unsigned word-type decimal format
(when the date and time (in "YYYY/MM/DD hh:mm:ss.s" format), data sampling interval, execution
step No, execution program name, and index columns are selected for output)
21 (date and time) + 12 (data sampling interval) + 6 (execution step No.) + 8 (execution program
name) + 10 (index) + (6 × 128) (data) + 132 (number of commas) + 2 (CR + LF)
= 959 bytes
*10 When a CSV file is opened in Excel, the date and time column is displayed in the default format of Excel. Format the
cells if needed.
To display information of year, month, day, time, minute, second, and millisecond, specify the following user-
defined display format.
yyyy/mm/dd hh:mm:ss.000
Item Description
Size
*9
Date and time column
Date and time information is output.
*10
1 to 32 bytes
Data sampling interval
column
A time interval between the previous and current sampling events is output.
*1
(Unit: µs, Range: 1 to 100000000000)
*2
1 to 12 bytes
Execution step No.
column
An execution step No. is output.
*6
1 to 6 bytes
Execution program name
column
An execution program name is output.
*7
1 to 8 bytes
Index column
An index No. of the data sampled in data logging is output.
*3
(Range: 1 to 4294967295)
*4
1 to 10 bytes
Data column
When bit is specified: Bit ON = 1, or bit OFF = 0 is output. 1 byte
When unsigned word or double-word type is specified:
Data are output in the format specified among decimal, hexadecimal, and exponential
formats.
Decimal format: 1 to 6 bytes
Hexadecimal format: 1 to 4 bytes
Exponential format: 5 to 21 bytes
When signed word or double-word type is specified:
Data are output in the format specified among decimal, hexadecimal, and exponential
formats.
Decimal format: 1 to 11 bytes
Hexadecimal format: 1 to 8 bytes
Exponential format: 5 to 22 bytes
When single- or double-precision real number is specified:
Data are output in the specified decimal
*8
or exponential format. When the specified data
type is not applicable to the data, "NaN" is output in the data line. For the value range
applicable to each real number type, refer to Page 38, Section 3.3.3.
When string type is specified: A string of characters in the specified size is output. If "0" is
included in the data, the data after the "0" is not output because it indicates the end of the
string.
*5
1 to 256 bytes
When raw type is specified: Data are converted into hexadecimal characters in byte units,
and output without any space.
2 to 512 bytes
Trigger information
column
The line, where a trigger has occurred, is output. 0 to 32 bytes
Ex.
Ex.
To Next Page
Loading...
