Subject: | AnyData adTie CSV problem |
AnyData-0.10 used on a Windows platform with an Excel generated CSV file.
File contains column headers and three rows of data, first column intended to be the default key. Here is the left edge of the CSV file:
name,source,heat_capacity,hc_units
Graphite,Poco AXF-5Q,691,J/(kg*K)
nSiGi,GE,647,J/(kg*K)
pSiGe,GE,647,J/(kg*K)
with the following syntax:
$tbl = adTie ( 'CSV', 'mydata.csv', 'r', {key=>'name'} );
print "COLUMNS: ". join '|',adNames($tbl)."\n";
print join '|',adColumn ( $tbl, 'name' )."\n"
produces the following strange output:
COLUMNS: 29
3
HASH(0x1c7f75c)|HASH(0x1c7f864)|HASH(0x1c82e08)
Further examination suggests that the hash keys in the tied has are these HASHrefs shown above, and I cannot access any data except the first row using the syntax suggested in the documentation.
sloughin@wamsystems.com