Export (0) Print
Expand All

UseHeader Property

Specifies whether the first line of the data file contains header information.

Syntax

[ fValue = ] TDC.UseHeader

Possible Values

fValue Boolean expression that indicates that the data file contains an initial line that names each column and optionally specifies its data type.

The property is read/write. The property has no default value.

Remarks

The default value for fValue is false, which specifies that the first line of the data file does not contain header information. If fValue is true, the first line of the data file should match the following layout:


fieldname:type,fieldname:type, ...

Notice that the above assumes the default field and row delimiters (comma and newline, respectively).

The fieldname can be an arbitrary text string, although it is best to avoid spaces and other punctuation characters.

The type is optional, and can be one of the following values:

StringTextual data (default)
DateDate can be optionally followed by a space and then the letters D, M, and Y in any order. These correspond to Day, Month, and Year and control the interpretation of the dates in the data file. The date data is treated as three numbers separated by characters, so the actual separation character is not important.
BooleanLogical data (Yes/No, True/False, 0/not 0). Boolean will interpret the following data:

True values: Yes, True, 1, -1, any nonzero number

False values: No, False, 0 (zero)

IntIntegral numbers (-3, 1, 5)
FloatFloating-point numbers (3.141, 2.77, 0). The decimal separator used by float data is determined by the Language property.

Example

The following sample data file shows how the various data types can be declared when UseHeader is set to true and the default settings for FieldDelim, RowDelim, and Language are used.


FoodItem,Price:Float,Purchased:Date YMD,OnOrder:Boolean,Quantity:Int
Bread,1.57,97/5/12,Yes,30
Cheese,3.52,96/2/2,No,5
Old Wine,183.99,1905-1-1,No,1

Applies To

TDC

See Also

Community Additions

ADD
Show:
© 2014 Microsoft