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