Copyright: (c) 2000 Campbell Scientific, Inc.


Writing Reports and Extracting Data with Split

You can generate reports and manipulate data files with Split. Split allows you to:

•	Split large data files into smaller, more easily analyzed files.

•	Sort and combine data based on time or conditions.

•	Process data using arithmetic operators, math functions, spatial functions, and time series functions.

•	Create output files that are compatible with spreadsheet programs.

Where to go for Help

•	Hints are automatically provided at the bottom of the screen as you move the cursor.

•	Detailed help is available by pressing F1 or choosing Help | Contents from the menu.

	Cue Cards are available to help you set up Split for processing data. They can be accessed from this link or from Split's Help menu.

Getting Started!


Getting Started

	Refer to our Cue Cards for step-by-step instructions on setting up Split for your application!

Step #1

Complete the Input File Template.

Step #2

Complete the Output File Template.

Step #3

Select Run | Go from the Split Menu.

This help file provides information on all of Split's features, including a description of the menu items.


Splitr

Splitr is a run-time version of Split that is called from a command line, a batch file, or PC208W's Task line.

Splitr Switches:

/R	Closes Splitr and returns to the Windows environment after the PAR file is run.  No space should be between the parameter file name and the /R switch (e.g., splitr.exe test.par/r).  Otherwise you'll receive the message: "There was a problem opening the input file.  File could not be found or may be in use."

/M	Runs multiple copies of Splitr at one time.  The /M command must be the first element after the Splitr command (e.g., splitr.exe /M test.par)

/H	Runs Splitr in a minimized state.  This command must be positioned after SPLITR.EXE but before the parameter file name, and a space is required between the executable name and the switch (e.g., splitr.exe /H test.par)

Note:  When using the /M switch in a batch file under Windows NT, you must begin each line of the batch file that runs an instance of Splitr with the "start" command.  Otherwise, NT will wait until the first Splitr command has finished before proceeding to the next.


Split Menu

The menu bar appears at the top of the Split screen at all times and contains these options:

•	Menu -- File

•	Menu -- Edit

•	Menu -- Labels

•	Menu -- Run

•	Menu -- Printer

•	Menu -- Help


File

New

Creates a new Parameter file.  For information about Parameter Files, see Parameter Files.

Open

Opens an existing Parameter file.

Save

Saves the changes made to the Parameter file.

Save As

Creates a new Parameter file by saving the file you are working on under a new name.

Exit

Exits Split.  If your current Parameter file has changes that have not been saved, Split will ask whether you want to save the changes.


Parameter Files

Split creates a parameter file (filename.PAR) that defines:

•	Which data files are read.

•	What operations are performed on the data set.

•	Where the final results will be saved.

The parameter files may be saved (File|Save or File|Save As) and used again.


Edit

Cut

Allows text to be moved to another area of Split.  For a step-by-step procedure on moving text, see Cut, Copy, and Paste Procedures.

Copy

Allows text to be copied to another area of Split.  For a step-by-step procedure on moving text, see Cut, Copy, and Paste Procedures.

Paste

Inserts text, which has been cut or copied, at the cursor location. For a step-by-step procedure on moving text, see Cut, Copy, and Paste Procedures.

Add Data File

A consolidated data file can be created from up to eight data files using the Add Data File function.  The resulting output file will display the specified elements from each data file in rows.  For instance, if data file 1 (DF1) has 4 elements and data file 2 (DF2) has 3 elements, the output file will be formatted as:

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7

   DF1-1	DF1-2	DF1-3	DF1-4	DF2-1	DF2-2	DF2-3

where DF1-1 is data file 1, element 1; DF1-2 is data file 1, element 2, and so on.

A separate Input File template is created for each data file that is added.  For an example of using the Add Data File function while time synchronizing two files, refer to Combining Two Arrays Using Time Synchronization.

Delete Data File

Select this menu option to delete the active input file template from the parameter file.


Cut, Copy, and Paste Procedures

The following steps are required for moving or copying text:

(1)	Either use the computer's mouse or the <shift> and arrow keys to select all of the text that will be moved or copied.

(2)	Select EDIT|CUT to move the text or select EDIT|COPY to copy the text.

(3)	Move the cursor to the location where the moved or copied text will reside.

(4)	Select EDIT|PASTE; the text is now moved or copied to the designated location.

Steps 3 and 4 can be repeated allowing text to be copied to many areas of the program.


Labels

Accesses a window that allows you to select fields and label columns using Final Storage Labels (.FSL file).  These labels can be pasted to the Copy, Select, and Column Headings fields.

For more information, see Data File Label window.


Data File Label Window

Output Arrays

Lists the arrays described in the label file.

Select File

Select this button to select another Final Storage Label file.  These are the files that contain the labels.

Paste

Select this button to paste the selected labels in the select line or the column label.

Field Names

List available field names.  From this list, you can double click to paste the field number.

Output Interval:

Displays the frequency that the selected array is stored.

Field Number:

Displays the field (column) number of the field that is under the cursor.


Run

Go is the only menu item under Run.  Select Go to compile and execute the Split file.


Printer

Accesses a dialog box where you can select the font for any report that's output to the printer.  For information about outputting reports to the printer, see Report options.


Help

Contents

Accesses Split's Help Table of Contents.

About

Lists the version number and date for the Split that you are using.


Input File

Defines the data that will be used to create your report. Click any area on the graphic below for further information.

Input File Template Examples


Input File -- Browse

Select this button to access a window that allows you to select an input file.  The filename of the input file that is currently being used is displayed in the box that is to the right of the browse button.

Note:  Input files must be formatted in Comma Separated ASCII, Final Storage Format, Field Formatted ASCII, Printable ASCII, or Raw A/D data (burst mode).


File Info

Auto Detect

Select this option for all input file formats except the Raw A/D data (burst mode) and when an offset has been set for a file with a Final Storage (binary) format.

Final Storage Format

Select this option only when a file is in Final Storage (binary) format and an offset has been set.

Note:   Selecting the Final Storage Format when the file is not in a Final Storage (binary) format confuses Split because it's searching for binary values that are not found in ASCII files.

Burst

Select this option if the data in your input file were generated by the datalogger's burst mode.


Offset

Select this button to access a window that allows you to change your offset settings.

The window accessed by this button is divided into three sections:

•	Start Offset

•	Stop Offset

•	Number of values in each burst

The offset window also provides these buttons:

•	OK

•	Cancel


Start Offset

None

Enable this check-box to start reading the input file from the beginning.

Last Count

Enable this check-box to start reading the input file from where Split had last read.  This can be used to process only the new data.

Specific

Enable this check-box to start reading the input file after a specific number of bytes.  Enter a postive number in the box to the right of this check-box to start counting at the beginning of the file; enter a negative number to start counting at the end of the file.  All characters including spaces, carriage returns, and line feeds are counted.


Stop Offset

Enter the number of bytes to read before ending execution.


Number of values in each burst

Enter the number of elements to read for each Burst.  This number does not include the array ID or calibration data.


OK

Select this button to close the window and incorporate all changes.


Cancel

Select this button to close the window and ignore all changes.


Start Condition

Enter the condition(s) that must occur before Split will start processing data.  Separate individual entries with a comma (e.g., 3[12], 5[10], 10[23] enters three conditions).

To process data from the beginning of the file, leave this parameter blank.

For information about entering start conditions, see:

•	Basic syntax

•	Ranges for values

•	Logical "and" & "or"

•	Time-sync function


Basic syntax

Enter in the form of E[n] where:

E -- the element number in the array

n -- a value that must occur for the array element before Split starts reading, stops reading, or copies data.

Example:   With an entry of 6[10], Split will start reading, stop reading, or copy data when the sixth element in the array has a value of 10.


Ranges for values

Indicate ranges by entering two periods between the first and last value of the range.

Example:   With an entry of 6[3..10], Split will start reading, stop reading, or copy data when the sixth element in the array is between 3 and 10.


Logical and & or

Logical and can be entered to specify that all conditions must occur before Split starts reading, stops reading, or copies data.

Logical or can be entered to specify to start reading, stop reading, or copy data when one of the conditions occurs.

Up to six elements connected by or statements can be entered, and up to three elements connected by and statements for each or can be entered. If the maximum number of logical statements is exceeded, an error message will be displayed.

Examples:

With an entry of 6[10] and 15[2], array element 6 must equal 10 and array element 15 must equal 2.

With an entry of 6[10] or 15[2], array element 6 must equal 10 or array element 15 must equal 2.

With an entry of 6[10] and 15[2] or 15[5], array element 6 must equal 10 and array element 15 must equal 2 or Array element 15 must equal 5.


Time-sync function

The time-sync function is used to begin processing a data file based on the current PC time, or to synchronize the data in two or more files based on their time stamps. In this latter instance, the Copy Condition must include a time element with an interval specified in brackets.

For information, see:

•	Starting relative to PC time

•	Synchronizing two or more data files

•	Example: Combining Two Data Files Using Time Synchronization

Caution:  Split will not start processing a file if the exact specified starting time cannot be found.


Synchronizing Two or More Data Files

When time synchronizing two or more data files, the files can be synchronized from the beginning or a Start Condition can be specified.  Below are example Start Condition entries for enabling time synchronization.

Split tries to time-sync files to the top of the hour when starting relative to PC time.  If you are synchronizing files where the data output interval is not at the top of the hour, you will need to specify an interval in the Copy Condition that represents a window of time in which Split should look for the hour/minute.  For instance, if your data is output 50 minutes into a 60 minute interval (and therefore, your timestamps are 50, 150, 250, 350...2350) your Start Condition and Copy Conditions for the first file might look like the following:

Start Condition

2[-1]:3[50]

Copy Condition

1[106]and3[60,10]

Where:

element 1 is the array ID

element 2 is the Julian day

element 3 is the hour/minute

The Start Condition directs Split to begin processing data when the time is one day prior to the current PC time and when the hour/minute value is equal to 50.  The 1[106] in the Copy Condition specifies the array from which the data should be copied.  The 3[60,10] indicates that the interval for the time stamp is 60 minutes and designates a 10 minute time window on each side of the top of the hour in which Split should look for the hour/minute data (10 minutes before the hour, 10 minutes after the hour).

The second file's Copy Condition should include only the array from which to copy the data.  No interval is necessary.

For step-by-step information on Time-Synchronizing files, refer to the Cue Cards.

Notes:

•	The start condition must be entered for each file.

•	To keep the output synchronized in multiple files, a time interval must be entered in the Copy Condition field. This interval is entered in minutes. Valid entries are 1 through 1440. A typical Copy Condition entry would be 1[101]and4[60], where 1[101] specifies the array from which to copy data, 4 is the hour/minute element and 60 represents a one hour interval.

Time-sync two or more files from the beginning of the files, based on the day, hour, and minute (no specific Start Condition set)

Enter in the form of:    D:H:

Time-sync to a specific day, hour, minute, and second

Enter in the form of:   D[day]:H[hrmin]:S[sec]

Time-sync to a specific day, hour, and minute

Enter in the form of:   D[day]:H[hrmin]:

Time-sync to a specific day

Enter in the form of:   D[day]::

Time-sync to a specific hour, minute, and second

Enter in the form of:   :H[hrmin]:S[sec]

Time-sync to a specific hour and minute

Enter in the form of:   :H[hrmin]:

Time-sync to a specific second

Enter in the form of:   ::S[sec]

Where:

D 	the element number in the array that lists the day

day 	the Julian day of the year the data will be time-synched to

H 	the element number in the array that lists the hour

hrmin	the hour and minutes the data will be time-synched to (military time)

S	the element number in the array that lists the seconds

sec	the seconds the data will be time synched to

Examples:

2[189]::             	Split starts reading data when array element 2 is the 189th day in the year.

:3[1200]:          	Split starts reading data when array element 3 is 12 noon

:3[1015]:4[5]    	Split starts reading data when array element 3 is 10:15 a.m. and array element 4 is 5 seconds

2[189]:3[1400]:	Split starts reading data when array element 2 is the 189th day in the year and array element 3 is 2:00 p.m.

Caution:  Split will not start processing the file if the exact specified starting time cannot be found.


Starting relative to the PC time

This option allows you to start processing a file based on the current time reflected by your PC.  A typical use of this option is to output a daily report by specifying a start condition of one day prior to the current PC time.  Processing the file based on the PC time alleviates the need to change the start condition each time the .PAR file is run.

Notes:

If the start time is a certain number of days prior to the PC time, the file will be processed beginning at midnight of the day specified.

To specify a start time in minutes from the current PC time, you must also specify a day parameter of [-0].  Otherwise, processing will begin at the first instance in the data file that the minutes parameter equals the current minutes.

If you are specifying a start time in minutes from the current PC time, the time you specify cannot be a value that would push the start time past midnight (e.g., at 9 a.m., specifying a start condition of 2[-0]:3[-600], which would be a start time of hour/minutes equals 2300).  If you do, the start condition is never found and the file is not processed.

Examples:

2[-2]:3[400]	Split starts reading data when array element 2 is two days earlier than the Computer Clock's Day and when array element 3 is 4 o'clock.

2[-2]:3[400,5]	Split starts reading data when array element 2 is two days earlier than the Computer Clock's Day and when array element 3 is the closest 5 minute interval that is less than 4 o'clock.

2[-0]:3[-60,5]	Split starts reading when array element 3 is the closest 5 minute interval that is less than the Computer Clock's minutes minus 60.

Caution:  Split will not start reading if the exact specified starting time cannot be found.  The interval must be evenly divisible into 60 minutes.


Stop Condition

Enter the condition(s) that must occur before Split will stop processing data.  Separate individual entries with a comma (e.g., 3[12], 5[10], 10[23] enters three conditions).

Leave blank if you want Split to read until the end of the input file.

For information about entering stop conditions, see:

•	Basic syntax

•	Ranges for values

•	Logical "and" & "or"

Notes:

If the Trigger on Stop Condition check-box has been enabled for the output file, the STOP condition will trigger the Time Series Processing and data will be read until the end of the input file.  For more information, see Output File -- Other button.

If C is specified before the STOP condition and the COPY condition is not met before the STOP condition, blanks are output.  This C option reads data until the end of the input file.


Copy Condition

Enter the condition(s) that must be met for Split to process an array of data.  If two or more conditions are specified, they must be joined logically with an "and" or "or" expression.

When this field is left blank, all arrays from the data file will be processed.

For information about entering copy conditions, see:

•	Basic syntax

•	Ranges for values

•	Logical "and" & "or"

The Copy Condition is also used to specify the data interval when Time-Syncing two or more data files.  For additional information, see Synchronizing two or more data files.


Select

Selects the elements and data processing that are sent to the output file.  Commas separate entries; two periods between two numbers indicate a range (e.g., 3..5 means 3, 4, 5).

This entry becomes operable after the start and copy conditions have been met and before the stop condition is satisfied.  To select all data that meet the start and copy conditions, leave this line blank.

For more information, see:

•	Operators

•	Functions

•	Time Series functions

•	Special functions

•	Range Testing

•	Variable Names


Operators

One select line can include several operators and functions.  Operators and functions that are enclosed in parentheses are calculated first; the inner most parentheses are evaluated first.

Operator List

*	multiply

/	divide

+ 	add

- 	subtract

^ 	raise to the power of

x Mod y	modulo divide

An entry that uses operators can include both array element numbers and fixed numbers; enter fixed numbers with a decimal point or in scientific notation (e.g., 10E3 for 10,000, 2E-3 for 0.002).


Math Functions

One select line can include several operators and functions.  Operators and functions that are enclosed in parentheses are calculated first; the inner most parentheses are evaluated first.

Math Function List

Abs(x)	absolute value

Arctan(x)	arctangent (angle in degrees)

Cos(x)	cosine (angle in degrees)

Exp(x)	exponent of e (Exp(2.) = e^2)

Frac(x)	takes the fraction portion (Frac(2.78)=.78)

Int(x)	takes the integer portion (Int(2.78)=2)

Ln(x)	natural logarithm

Sin(x)	sine (angle in degrees)

SpaAvg(x..y)	spatial average

SpaMax(x..y)	spatial maximum

SpaMin(x..y)	spatial minimum

SpaSd(x..y)	spatial standard deviation

Sqrt(x)	square root

To enter a function, type in the function name, then the value for the text enclosed in parentheses.  Except for the spatial functions, the text between the parentheses can be an array element, a fixed number, or an expression (e.g., Abs(5-1.)); enter fixed numbers with a decimal point or in scientific notation (e.g., 10E3 for 10,000, 2E-3 for 0.002).

Spatial functions require a group of element array numbers to be entered between the parentheses (e.g., SpaAvg(1..10), SpaAvg(1,5,10)).


Time Series Functions

Time Series results are output at the end of the file, when an interval count (n) is met, or when the F option is enabled and a stop condition is met.  The interval count (n) for each of the functions is optional.

Time Series Function List

Avg(x;n)	average

Blanks(x;n)  	number of blanks or bad data

Count(x;n)	number of data points

Max(x;n)	maximum

Min(x;n)	minimum

RunTotal(x;n)	running total of element x

Sd(x;n)	standard deviation

Smpl(x;n)	sample

SmplMax(x;y;n)	sample (y) on a maximum (x)

SmplMin(x;y;n)	sample (y) on a minimum (x)

Total(x;n)	total

WAvg(x;n)	unit vector mean wind direction (in degrees)

One select line can include several operators and functions.  Operators and functions that are enclosed in parentheses are calculated first; the inner most parentheses are evaluated first.

To enter a time series function, type in the function name, then the value for the text enclosed in parentheses.  The text between the parentheses must include the array element number(s).  To output the results at an interval count, enter a semicolon after the array element number(s) then the interval count.

The SmplMax and SmplMin functions require two elements separated by a semicolon.  The first is checked for a max or min, while the second is sampled on the max or min.


Special Functions

One select line can include several operators and functions.  Operators and functions that are enclosed in parentheses are calculated first; the inner most parentheses are evaluated first.

Special Function List

crlf	Inserts a carriage return line feed in the Output file

Smpl(.PA;n)	Inserts a page break in the report file or printed output every n number of lines.

Line 	Numbers each line written to the report file or printer

"label"	Inserts a comment to the Output file.  The label is any text between the quote marks.

Date(doy;y)	Converts Julian day to a MM-DD format (MM is month; DD is day).  doy = the element number for the day of the year; y = the element number for the year.  If the year does not exist in the data file, a constant (followed by a decimal point) can be entered.

EDate(doy;y)	Converts Julian day to a DD-MM format (DD is day; MM is month).  doy = the element number for the day of the year; y = the element number for the year.  If the year does not exist in the data file, a constant (followed by a decimal point) can be entered.


Range Testing

Selects the array element only when its value is within the specified range.

Range tests are entered in this form:

E[L..U]

Where,

E	array element number

L	lower limit

U	upper limit

Typically when a value is out-of-range, the screen will display asterisks and the text "Bad Data" will be displayed in a red box at the bottom right of the screen; the output file will have blanks.  However, some output options affect the way the screen and the Output file deal with out-of-range values (see table below).


Variable Names

Variables can be assigned names in the select parameter.  Once a variable is named, the name can be used later in the select parameter.  A comma must follow each variable statement.

To name a variable, type in the variable name followed by an equal sign and then the variable (e.g., x=4-5(6*3.0) assigns the variable 4-5(6*3.0) the name x).

Entering Variable Names:

•	Names must start with a letter

•	Other characters may be letters or numbers

•	Length can be up to eight characters

•	One variable name cannot start with another complete variable name


Output File

Defines column headings, output options, and other report features. Click any area on the graphic below for further information.

Output File Template Examples


Output File -- Browse

Select this button to access a window that allows you to select an output file.  The filename of the output file that is currently being created is displayed in the box that is to the right of the browse button.


Screen Display

Enable this check-box to display the data while Split is processing it. When working with large data files, this option can be disabled to speed up data processing.


File Format

No File

When No File is selected, no output file will be saved to disk or printed as a report. The results of Split will be displayed on the Split Run Screen if the Screen Display check-box is enabled.

Field

Strips all IDs, leading and trailing zeros, unnecessary decimal points, and plus signs.  Lists the data in columns; arrays are separated by Carriage Return Line Feeds.  The fixed spacing of the data points make specific data easy to locate on a printed output.

Comma Separated

Strips all IDs, leading and trailing zeros, unnecessary decimal points, and plus signs.  Individual data points are separated by commas; arrays are separated by Carriage Return Line Feeds.

Printable ASCII

Precedes each data point with a two-digit ID and a plus or minus sign.  The ID and fixed spacing of the data points make specific data easy to locate on a printed output.


Column Width

Enter the number of characters each column will have.  This number affects all columns in your report.

Valid entries are numbers from 6 to 9; the default is 8.


Report

File

Enable this check-box to write a report file to a disk.  The file name will be the output file name with a .RPT extension.

Printer

Enable this check-box to send the report file to a printer.

None

Enable this check-box if you do not want a report saved to disk or sent to a printer. The only output file that will be produced is a PRN file.


Other button

Select this button to access a window that provides options for handling out-of-range data and allows special data processing.

The window that is accessed by this button is divided into three sections:

•	Bad Data

•	Processing

•	Special

The Other window also provides these buttons:

•	OK

•	Cancel


Bad Data

Replace data with:

Enter the character you want the out-of-range data to be replaced with.  This can make your report easier to read, especially if there are a lot of out-of-range data.

Only display lines with bad data

Enable this check-box to output the arrays that have one or more out-of-range data.  This is typically done to help determine why the data are out-of-range.


Processing

Trigger on Stop Condition

Enable this check-box to process data with time series functions when the data meets the Stop Condition.

For more information about time series functions, see Select.


Special

Match Files

Enable this check-box to compare two files of the same data.  If good data exists in one file and not the other, Split fills the Output file with the good data.  This is used to get a more complete record from an error-ridden file by reading the file twice and running both files through Split.

Caution:  To produce an accurate output file, the files must contain the same measurements and they must have the same Start condition.

Transpose File

Enable this check-box to transpose the rows and columns of the input file.  Only one input file can be transposed at once and no select options can be specified (see Select).

The transpose feature is limited to transposing 26 arrays at one time.  This results in an output file of 26 columns by X rows when transposed, where X is the number of elements in your array.

If the data file has more than 26 arrays to be transposed, you can process the file multiple times with the Last Count option enabled (see Last Count ).  Because Split does not append to the output file, but overwrites it, a new output file will need to be specified with each pass through the data file.  The resulting output files can then be combined by creating a parameter file that combines multiple data files using the Edit | Add Data File and running that parameter file (see Edit | Add Data File).

No FF

Enable this check-box to suppress form feeds and page breaks when the Report option is File or Printer (see Report).  When this option is enabled, a header appears on the first page only.  This option is most often used for printing reports on continuous feed paper.

Break Arrays

Breaks an array into multiple arrays.  Type-in the number of elements to include on one data line.  Each line will begin with the array ID followed by the specified number of elements.  For example, if your array has 7 elements (the array ID plus 6 other values), and a 3 is specified for Break Arrays, for each array your output file would have the format:

ArrayID	Element 1 Element 2 Element 3

ArrayID	Element 4 Element 5 Element 6

Note:   Break Arrays is typically used for Burst data.


Report Heading

Enter the heading that will appear at the top of your report.

A \ denotes a new heading line.

Notes:  Headings are used when the Report option is either File or Printer (see Report).  Heading lengths for the Report Heading and Time Series heading combined are limited to 253 characters and spaces.  If these two fields contain more than 253 characters combined, the text will be highlighted in red, and an error will be returned if you try to run Split.


Column Labels

Col #

Displays the column number.

Element/Field #

Displays the array element.

Filename

Displays the input file name.

Line 1, Line 2, and Line 3

Enter the label for this column.  A column's label can have up to three lines.  The top, middle, and bottom lines are entered in the Line 1, Line 2, and Line 3 boxes, respectively.

Each line is limited to one character less than the number designated in the Column Width parameter (see Column Widths).  All three lines combined cannot have more than 17 characters.

Decimal

Enter the number of digits to the right of the decimal that the column's data will be rounded.  Leave blank if you do not want to round the data to a specific number of digits.

Insert

Select this button to insert a column at the cursor.

Delete

Select this button to delete the column at the cursor.

Add

Select this button to add a column at the end.

Notes:

Column labels are used when the Report option is either File or Printer (see Report).

Split is limited to writing 20 column headers per input file.  You can work around this 20 column limit by adding another data file (Edit | Add Data File), assigning it the same data file name, and putting any elements over 20 on the second file's select line.


Time Series Heading

Enter the title for the report's Time Series data.  A \ denotes a new line.

Note:    Heading lengths for the Report Heading and Time Series heading combined are limited to 253 characters and spaces.  If these two fields contain more than 253 characters combined, the text will be highlighted in red, and an error will be returned if you try to run Split.


Input File Template Examples
Cue Cards: Input File Template Examples

	These Cue Cards were designed to help you set up Split for a particular data processing task. Just select an example and complete Split's Input and Output Templates as suggested on the screen.
Basic Split Operation

A simple parameter file to output all lines of data that have the same array ID.

Final Storage Labels

An example of using the Final Storage Label file (*.FSL) to fill in the Split Input File template.

Start Condition

Examples of Start Condition entries to start processing data when a specified condition is met.

Stop Condition

Examples of Stop Condition entries to stop processing data when a specified condition is met.

Time Series Functions

A parameter file to perform additional calculations on collected data, based on a specified interval.

Trigger on Stop Condition (F Option)

A parameter file that outputs time series data when a specified condition is met.

Combining Arrays

A parameter file that uses time synchronization to combine data from two unique arrays.

Testing for Bad Data

A parameter file to help determine "bad" or out-of-range data values.

Automatic Data Processing

An example of setting up PC208W to automatically process data at a specified time.

Output File Template Examples


Basic Split Operation (Example)

Consider the following arrays from a data file:

111,1998,61,1206,22.79,73

111,1998,61,1207,22.89,73.2

111,1998,61,1208,22.8,73

111,1998,61,1209,22.74,72.9

111,1998,61,1210,22.76,73

222,1998,61,1210,14.05,23.32,-.561,73,22.76,22.82

In array 111 the date, time, and two parameters are saved in Final Storage each minute. In array 222, additional parameters are saved every five minutes.

A parameter file can easily be set up to save all the data from array 111 in an output file.

 Next


Basic Split Operation

Enter the data file name in the Input Data File field. You can search for an input file by selecting the Browse button.

In the Copy field, type: 1[111]

This instructs Split to copy data only from the arrays that have 111 as element number 1.

Tip:

The array ID is always the first data value in an array. Therefore, it is always element number 1.

 Next


Basic Split Operation

Complete the information on the Output File tab.

From the toolbar menu, select Run | Go.

All data from array 111 will be saved to a file and/or printed depending upon the information completed on the Output File tab.

More Examples


Element

Split refers to each data value as an element. In the sample array below, the elements are separated by commas:

111,1998,61,1206,22.79,73

111 is element 1, 1998 is element 2, 61 is element 3, 1206 is element 4, 22.79 is element 5, and 73 is element 6.


Using the Final Storage Label File to Complete an Input File Template (Example)

Enter the data file name in the Input Data File field. You can search for an input file by selecting the Browse button.

 Next


Using the Final Storage Label File to Complete an Input File Template

From the Split menu, choose Labels | Use Final Storage Labels. A Data File Labels list box appears:

 Next


Using the Final Storage Label File to Complete an Input File Template

1.	Choose Select File to invoke a dialog box that displays the Final Storage Label files.

2.	Click on the *.FSL file that has the same name as the datalogger program associated with your data file.

3.	Select OK.

The Data File Labels list box should show the arrays contained in the data file. When an array is highlighted, the Input Location labels for each element in the array appear in the Field Names column of the list box.

 Next


Using the Final  Storage Label File to Complete an Input File Template

To copy the Array ID element into the Copy field of the template:

1.	Highlight the Array ID in the Output Arrays column of the list box.

2.	Click inside the Copy field.

3.	Press the Paste button.

To copy other data elements into the Select field of the template:

1.	In the Field Names column of the list box, highlight the elements you want to output.

2.	Click inside the Select field.

3.	Press the Paste button.

Press Done to close the Data File Labels list box.

Tip:

If you get the message Cannot Paste There, the mouse cursor is not placed in a valid field. Click inside the Copy or Select field and try again.

Each element you Paste into the Select field will be included in the output file. Elements will be output in the order they appear in the Select field.

More Examples


Start Processing Examples

The following sample data will be used for the examples. The data is presented in a table so it is easier to read.

Examples

Start Processing on day 61

Start Processing on day 61 at 12:00

Start Processing when Value 2 is between 74 and 75

Start Processing when Value 2 is between 74 and 75, or time is 24:00

Start Processing on day 61 at 12:00, or when Value 1 is between 21 and 22

Start Processing the previous day at 12:00.

Related Topics

More Examples


In the Start Condition Field enter:

3[61]

Data processing will begin when element 3 (day) equals 61.


In the Start Condition Field enter:

3[61]and4[1200]

Data processing will begin when element 3 (day) equals 61 and element 4 (time) is 1200.


In the Start Condition Field enter:

6[74..75]

Data processing will begin when element 6 (value 2) is between 74 and 75.


In the Start Condition Field enter:

6[74..75]or 4[2400]

Data processing will begin when element 6 (value 2) is between 74 and 75, or element 4 (time) is 2400.


In the Start Condition Field enter:

3[61]and4[1200]or 5[21..22]

Data processing will begin when element 3 (day) equals 61 and element 4 (time) equals 1200, or element 5 (value 1) is between 21 and 22.


In the Start Condition Field enter:

3[-1]:4[1200]

This command uses the time synchronization function, which processes data relative to your PC's clock. Data processing will begin when element 3 (day) is one less than the current day and element 4 (time) is 12:00.


Stop Processing Examples

The following sample data will be used for the examples. The data is presented in a table so it is easier to read.

Examples

Stop Processing on day 61

Stop Processing on day 61 at 12:00

Stop Processing when Value 2 is between 57 and 58

Stop Processing when Value 2 is between 57 and 58, or time is 24:00

Stop Processing on day 61 at 12:00, or when Value 1 is between 15 and 16

Related Topics

More Examples


In the Stop Condition Field enter:

3[61]

Data processing will stop when element 3 (day) equals 61.


In the Stop Condition Field enter:

3[61]and4[1200]

Data processing will stop when element 3 (day) equals 61 and element 4 (time) is 1200.


In the Stop Condition Field enter:

6[57..58]

Data processing will stop when element 6 (value 2) is between 57 and 58.


In the Stop Condition Field enter:

6[57..58]or 4[2400]

Data processing will stop when element 6 (value 2) is between 57 and 58, or element 4 (time) is 2400.


In the Stop Condition Field enter:

3[61]and4[1200]or 5[15..16]

Data processing will stop when element 3 (day) equals 61 and element 4 (time) equals 1200, or element 5 (value 1) is between 15 and 16.


More Information
Related Topics

Start Condition Basics

Time Synchronization


More Information
Related Topics

Stop Condition Basics


Time Series Functions (Example)

Assume that our data file contains a week's worth of hourly data that looks similar to the data below. The data is presented in a table so it is easier to read.

By using the Average time series function, the average daily temperature (value 2) can be easily calculated.

 Next


Time Series Functions

Enter the data file name in the Input Data File field. You can search for an input file by selecting the Browse button.

 Next


Time Series Functions

To ensure that the data is processed from the beginning of a 24 hour interval, enter 4[1] into the Start Condition field. Data processing will begin with the first array that has a time stamp of 1.

In the Select field, enter the elements you want to include in the output. This can be done quickly using the Final Storage Label file (click here for an example.)

 Next


Time Series Functions

The syntax for the Average function is Avg(E;n), where E is the element number and n is the interval you want the function performed.

In the Select field, type Avg(6;24). The field should look similar to the example below:

Fill in the parameters on the Output Tab for your desired output format. Refer to the examples if needed.

 Next


Time Series Functions

From the toolbar menu, select Run | Go.

Split will calculate the average of element 6 (hourly temperature, degrees Fahrenheit) every 24th array (every 24 hours). The other elements in the Select field will be output each time they occur (i.e., hourly). The output should look similar to below:

Related Topics

More Examples


More Information
Related Topics

Time Series Function List


Combining Two Arrays Using Time Synchronization (Example)

Consider the following arrays from a data file:

111,1998,61,1206,22.79,73

111,1998,61,1207,22.89,73.2

111,1998,61,1208,22.8,73

111,1998,61,1209,22.74,72.9

111,1998,61,1210,22.76,73

222,1998,61,1210,14.05,23.32,-.561,73,22.76,22.82

In array 111 the year, day of year, time, and two parameters are saved in Final Storage each minute. In array 222, additional parameters are saved every five minutes.

Using time synchronization, data from these two arrays can be combined onto one output line.

 Next


Combining Two Arrays Using Time Synchronization

To process two arrays using time synchronization, two input file templates must be completed. For the first template, enter the data file name in the Input Data File field. You can search for an input file by selecting the Browse button.

Open another input file template by selecting Edit | Add Data File from the Split menu. Select the same data file name for this Input Data File field.

 Next


Combining Two Arrays Using Time Synchronization

In the Start Condition field of both files enter: 3[61]:4[1200]. This will start time-synchronized data processing when element 3 (day) is 61 and element 4 (hour) is 12:00.

Note:

The colon (:) alerts Split that the time synchronization function is being used.

 Next


Combining Two Arrays Using Time Synchronization

In the Copy Condition field of one file enter: 1[111]and4[1]; in the Copy Condition field of the other file enter: 1[222].

111 and 222 are the IDs for the data arrays. Adding the 4[1] entry will force the output to stay synchronized on a one minute interval throughout the file. (This interval needs to be specified in only one of the file templates.) Without this entry, the files would both start at 12:00, but would not be synchronized since array 111 is one minute data and 222 is 5 minute data.

In the Select field of both input file templates, enter the elements you want to include in the output. The elements you want to include from array 111 should be in the Select field for the template with the Copy condition 1[111], and the elements for array 222 should be in the Select field for the template with the Copy condition 1[222]. The Select fields can be filled in quickly using the Final Storage Label file (click here for an example.)

 Next


Combining Two Arrays Using Time Synchronization

Complete the information on the Output File tab.

From the toolbar menu, select Run | Go.

The data from both arrays will be on one output line. Where data does not exist, the fields will be left blank.

Your output file should look similar to the example below:

The array IDs, date, and time were included for both arrays to help clarify the example.

Note:

In this example, we used time synchronization to combine two arrays from the same data file on one output line. This same technique could be used to combine data from two different data files. Just remember that if using a Start Condition, it must exist in both files. For instance, if the time stamp for one file begins at 12:00 and the time stamp for the other file begins at 14:00, a time of 14:00 or later must be specified in the Start Condition or the second file will never be processed.

Related Topics

More Examples


More Information
Related Topics

Time Synchronization Entry Format

Starting Relative to PC Time


Testing for Bad Data (Example)

Consider the sample data file below:

111,1998,61,1200,69.1

111,1998,61,1300,73.5

111,1998,61,1400,75

111,1998,61,1500,6999

111,1998,61,1600,6999

This simple file provides the date, time, and temperature in degrees Fahrenheit (the temperature is element 5). It is obvious by reviewing the data that there is a problem beginning at 1500 hours. However, in a large data file, it might be hard to find this problem. Split has a Range Testing function that can be used to highlight questionable data values.

 Next


Testing for Bad Data

Enter the data file name in the Input Data File field. You can search for an input file by selecting the Browse button.

Complete the Start Condition, Stop Condition, and Copy Condition fields. Refer to the Examples if you need more information.

Note:

The Start, Stop, and Copy Condition fields are not required, but they help to refine your data processing operation.

 Next


Testing for Bad Data

The parameters for range testing are entered in the Select field. In this field type: 1,2,3,4,5[55..95].

This entry will output the array ID, year, day of year, and time, and will highlight any temperature data which is below 55 degrees and above 95 degrees. The data will be highlighted in different ways, depending on the output options chosen. (Refer to Range Testing for an explanation of these options.)

More Examples


Output File Template Examples

Basic Output File

The basics of setting up the Output File template.

Final Storage Labels

An example of using the Final Storage Label file (*.FSL) to fill in the Split Output File template.

Input File Template Examples


Basic Output File (Example)

Complete the information on the Input File tab. Refer to the examples if you need help.

 Next


Basic Output File

Enter the data file name in the Output Data File field. You can easily select a directory for an output file, or choose an existing output file, by selecting the Browse button.

 Next


Basic Output File

In the Report box, select the output option you desire for the file.

Tip:

If the report option None is chosen, the only output file that will be produced is the PRN file.

 Next


Basic Output File

From the toolbar menu, select Run | Go.

If the Screen Display box is checked, the data will be sent to the Split Run screen as it is processed.

More Examples


Using the Final Storage Label File to Complete an Output File Template (Example)

Complete the information on the Input File tab. Refer to the examples if you need help.

A column will be created automatically in the Output File template for each element contained in the Input File's Select field.

 Next


Using the Final Storage Label File to Complete an Output File Template

Enter the data file name in the Output Data File field. You can easily select a directory for an output file, or choose an existing output file, by selecting the Browse button.

 Next


Using the Final Storage Label File to Complete an Output File Template

From the Split menu, choose Labels | Use Final Storage Labels. A Data File Labels list box appears:

 Next


Using the Final Storage Label File to Complete an Output File Template

1.	Choose Select File to invoke a dialog box that displays the Final Storage Label files.

2.	Click on the *.FSL file that has the same name as the datalogger program associated with your data file.

3.	Select OK.

The Data File Labels list box should show the arrays contained in the data file. When an array is highlighted, the Input Location labels for each element in the array appear in the Field Names column of the list box.

 Next


Using the Final Storage Label File to Complete an Output File Template

To copy the names for each element into the Column Heading fields of the template:

1.	In the Field Names column of the list box, highlight the elements for which you want to copy names.

2.	Click inside the first column field.

3.	Press the Paste button.

Press Done to close the Data File Labels list box.

Tips:

Column heading length is limited to one less than the number of characters defined for the column width. If a Column Heading is highlighted in red (as in column 3 above), it is too long and should be edited.

The names can be pasted into the Column Heading fields one at a time, or all the names can be selected and pasted at once.

If you get the message Cannot Paste There, the mouse cursor is not placed in a valid field. Click inside a Column heading field and try again.

More Examples


Time Series Processing Using Trigger on Stop (F Option) (example)

The Trigger on Stop condition, or F option, changes the function of the Stop Condition when one or more Time Series functions are contained in the Select field. When a Stop Condition is met, the time series data is calculated and written to the output file. However, instead of stopping at this point, processing resumes and time series data is output the next time the Stop Condition is met. This continues until the end of file or until the user stops Split manually. This type of processing is a useful way to calculate daily averages for data logged in hourly arrays.

If you are processing one or more files and want this option to affect each file, the Trigger on Stop condition is enabled. If you are processing multiple files and want the option to affect one or more files, but not all of the files, the F option is used.

 Next


Time Series Processing Using Trigger on Stop

Assume that our data file contains a week's worth of hourly data that looks similar to the data below. The data is presented in a table so it is easier to read.

By using the F option in the Stop Condition field (or enabling the Trigger on Stop condition checkbox), we can convert the data to 24 hour averages for one or more of the elements.

 Next


Time Series Processing Using Trigger on Stop

Enter the data file name in the Input Data File field. You can search for an input file by selecting the Browse button.

 Next


Time Series Processing Using Trigger on Stop

To ensure that the data is processed from the beginning of a 24 hour interval, enter 4[1] into the Start Condition field. Data processing will begin with the first array that has a time stamp of 1.

Tip:

If this Start Condition is not specified and the data file does not begin at 1, the first 2400 hour output will not be a complete 24 hour average.

 Next


Time Series Processing Using Trigger on Stop

For our example, we want 24 hour averages for Values 1 and 2 (elements 5 and 6 in our array). In addition, we want a sample reading of the Array ID, year, day of year, and time. Format these elements using the Time Series Average functions. The Select field should look like the example below:

 Next


Time Series Processing Using Trigger on Stop

Now we need to set up the Stop Condition. The syntax for the F Option is F,E[n], where E is the element number and n is the value that will trigger the Stop Condition.

(1)	In the Stop Condition field, type F,4[2400].

(2)	In the Copy Condition field, type 1[111] (to designate the array from which the data will be copied).

If only one file is being processed, or if you want the option to affect all files, the Trigger on Stop Condition checkbox can be enabled instead of typing F, in the Stop Condition field. If the Trigger on Stop Condition is enabled, the Stop Condition field entry would be 4[2400].

 Next


Time Series Processing Using Trigger on Stop

To enable the Trigger on Stop Condition checkbox, click on the Output File tab and select the Other button.

Under Processing, select the box beside Trigger on Stop condition and choose OK.

Fill in the parameters on the Output Tab for your desired output format. Refer to the examples if needed.

 Next


Time Series Processing Using Trigger on Stop

From the toolbar menu, select Run | Go. Split will output the array ID, year, day of year, and time, along with the averages for Values 1 and 2 each time it encounters a condition where element 4 = 2400. The output should look similar to below:

Notes:

In this example the time series function Smpl(E) was used to output current values for the first four elements. The elements in the select line could have been entered as: 1,2,3,4,Avg(5),Avg(6). In this case, the first four elements would be output for each array 111, and the averages would be calculated and output when the Stop Condition was met. The output would be similar to that in the table below:

Related Topics

More Examples


Related Topics

Time Series Processing Example

Time Series Functions


Add

Select this button to add a column at the end.


Delete

Select this button to delete the column at the cursor.


Insert

Select this button to insert a column at the cursor.