Get records by column position instead of name

[marsg]

Hi

I'm not sure what I'm trying is feasible but I'd like your input.

I have *.csv created dynamically which I access in CR9 through ODBC. Everything works fine but I found a problem for deployment, the column name of the first column in the csv file changes according to timezone. I didn't find a way for it to have always the same name.

So my question is: Is there a way to get access to this table`s first column using a partial name (which would be unique) or by an index?

Thanks a lot
Marcel

 

[synapsevampire]

Not that I can think of within Crystal alone.

Perhaps the CSV file building process can Insert a header row into the beginning of the file at creation time, and omit the dynamic naming?

-k