Oriented ascii input file format types -41 – Campbell Scientific LoggerNet Datalogger Support Software User Manual
Page 339
Section 8. Working with Data Files on the PC
Split’s default output file, a field-separated ASCII format with a *.PRN file
extension, can be processed a second time if desired.
TABLE 8–1 provides an example of Comma Separated, Field Formatted,
Printable ASCII, and Table Oriented ASCII input file types. The data in the
various formats are identical. Each line of data represents an “Output Array”,
starting with an Output Array ID (in this case 115). Each data point in the
Output Array is referred to as an “element”. The element number is given in
the Printable ASCII format, and implied in the other formats. Data presented
in TABLE 8–1 is used for example purposes in the following sections.
TABLE 8-1. Comma Separated, Field Formatted,
Printable ASCII, and Table Oriented ASCII
Input File Format Types
COMMA SEPARATED
115,189,1200,89.6,55.3,25.36,270
115,189,1300,91.3,61.5,27.25,255.4
115,189,1400,92.7,67.7,15.15,220.1
115,189,1500,94.1,69,20.35,260.6
FIELD FORMATTED
115
189
1200
89.6
55.3
25.36
270
115
189
1300
91.3
61.5
27.25
255.4
115
189
1400
92.7
67.7
15.15
220.1
115
189
1500
94.1
69
20.35
260.6
PRINTABLE ASCII
01+0115 02+0189 03+1200 04+089.6 05+055.3 06+25.36 07+270.0
01+0115 02+0189 03+1300 04+091.3 05+061.5 06+27.25 07+255.4
01+0115 02+0189 03+1400 04+092.7 05+067.7 06+15.15 07+220.1
01+0115 02+0189 03+1500 04+094.1 05+069.0 06+20.35 07+260.6
Element 1 = Output Array ID# (115)
Element 2 = Julian day (189)
Element 3 = hour, minute
Element 4 = average temperature in deg. F
Element 5 = average soil temperature in deg. F
Element 6 = average wind speed in mph
Element 7 = wind direction in degrees
TABLE ORIENTED ASCII
"TOACI1","CR10T","15Minute"
"TMSTAMP","RECNBR","TCTempF_MAX","BattVolt_MIN"
"2002-02-26 10:30:00",0,73.97,13.99
"2002-02-26 10:45:00",1,74.03,13.98
"2002-02-26 11:00:00",2,74.53,13.98
"2002-02-26 11:15:00",3,74.82,13.98
"2002-02-26 11:30:00",4,75.23,13.98
Element 1 = Timestamp
Element 2 = Record Number
Element 3 = temperature in degrees F
Element 4 = minimum battery voltage
8-41