Process Help EXPFLD - copy a file expanding the number of records

 

Process Name	Menu Path	Link to Command Table
EXPFLD	Dataribbon |Data Tools | Data Tools | Expand File	Click here

 

• Introduction
• Files, Fields and Parameters
• Notes
• Example
• Errors

Introduction

Copies a file, while expanding the number of records so that a record is output for given increments of a start field until an end field value is reached.

How to use

A typical use is where there are properties defined over a range of sample numbers, and these are to be combined with other data entered for each sample. For example, suppose the file contains the following fields:-

BHID    Fromno    Tono    Density

where the Density is defined for the range of sample numbers in Fromno and Tono. EXPFLD could be used to expand this into a new file containing the fields:-

BHID Sample Density

This file contains a record of the Density for each sample number, and as such may be combined with other files in this format.

---

Files, Fields and Parameters

Input Files

Name	Description	I/O Status	Required	Type
IN	Input file containing numeric explicit fields START and END defining the range.	Input	Yes	Undefined

Output Files

Name	I/O Status	Required	Type	Description
OUT	Output	Yes	Undefined	Output file containing extra records between the given ranges, the actual value being held in field NEWFIELD.

Fields

Name	Description	Source	Required	Type	Default
START	Name of field giving the start of the range.	IN	Yes	Numeric	Undefined
END	Name of field giving the end of the range.	IN	Yes	Numeric	Undefined
NEWFIELD	Name of field in output file containing the value for the record within the range.	OUT	Yes	Numeric	Undefined

Parameters

Name	Description	Required	Default	Range	Values
INCRMENT	Increment to be applied to START within range.	Yes	Undefined	Undefined	Undefined

---

Notes

The records output are for values of *START, *START+@INCRMENT, *START+2*@INCRMENT etc until the value of *END for the input record is reached. This means that @INCRMENT must never be zero, or an infinite number of records lie between the values.

---

Example

!EXPFLD

&IN(COMDEN),&OUT(SAMDEN),*START(FROMNO), *END(TONO),*NEWFIELD(SAMPLE),@INCRMENT=1

 

This is the example given at the start of this section.

---

Error and Warning Messages

Message	Description	Solution
>>>  WARNING - RECORD nnnnnn HAS START nnnnnn.nn GT END nnnnnn.nn <<< >>>  ERR 131 <<< (recordno) IN EXPFLD	Warning; illegal record. The record is output unchanged.
>>>  FIELD DOES NOT EXIST <<< >>>  ERR 131 <<< ( fileno) IN EXPFLD	Either the *START or the *END field does not exist in the input file. Fatal; the process is exited.
>>>  FIELD NOT NUMERIC <<< >>>  ERR 132 <<< ( fileno) IN EXPFLD	Either the *START or the *END field was alphanumeric. Fatal; the process is exited.

 

---