Hi All,
I've been working on this problem for a while and I thought I better go to the experts.
I have several columns of data that have a description of the data on top.
Such as:
Time Dat1 Dat2 Dat3, etc..
## ### ### ###
## ### ### ###
These descriptions are all on the same row. Sometimes there in row 1 sometimes in row 2. One of my problems is that the data is not all in one order. Therefore Dat1 is sometimes in Col1 and Time in Col2 or some other weird combination. I have been trying to write some code that will recognize what the column is by looking at the description. Once it is recognized then it will do some arithmetic on the data below that column until it reaches the last data point in that column. Sometimes there is a blank cell between the description and the first data point. I have about 500-1000 lines per file and I have several hundred files per folder. Hence my reason for trying to automate this.
Any suggestions???
much appreciated.
I've been working on this problem for a while and I thought I better go to the experts.
I have several columns of data that have a description of the data on top.
Such as:
Time Dat1 Dat2 Dat3, etc..
## ### ### ###
## ### ### ###
These descriptions are all on the same row. Sometimes there in row 1 sometimes in row 2. One of my problems is that the data is not all in one order. Therefore Dat1 is sometimes in Col1 and Time in Col2 or some other weird combination. I have been trying to write some code that will recognize what the column is by looking at the description. Once it is recognized then it will do some arithmetic on the data below that column until it reaches the last data point in that column. Sometimes there is a blank cell between the description and the first data point. I have about 500-1000 lines per file and I have several hundred files per folder. Hence my reason for trying to automate this.
Any suggestions???
much appreciated.