T O P I C R E V I E W |
gaba |
Posted - 09/29/2002 : 4:09:30 PM Hi
I have been importing electrophysiology data into Origin 6.1 using the Bruxton Data Access 6.1 add on software. I often end up with a few extra columns at the end of my worksheets, and I was wondering if there was a simple way to detect empty columns and delete them using labtalk?
Thanks Mark Fry
|
2 L A T E S T R E P L I E S (Newest First) |
gaba |
Posted - 09/30/2002 : 10:05:55 AM That's perfect!
Thanks Mark Fry |
Mike Buess |
Posted - 09/29/2002 : 8:08:07 PM Hi Mark,
Here's one way. It checks each column starting with the last and deletes it if it contains no data points.
for(ii=wks.ncols;ii>0;ii--) { sum(wcol(ii)); // apply the sum() function to column #ii if(sum.n>0) break; // exit the loop if the column contains any data points del wcol(ii); // delete the column if not };
Mike Buess Origin WebRing Member |