| T O P I C R E V I E W |
| 19102208 |
Posted - 04/21/2005 : 05:41:20 AM
Origin Version (Select Help-->About Origin): 6
Operating System:
Is there any option for filtering data, for example
2 5
3 6
2 7
than filtering the column 1 with the data "2" and get the resulut
2 5
2 7
Thanks for help. |
| 3 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 04/21/2005 : 11:26:03 AM
>How to extract the first n rows data from AB to CD, and the rest (N-n) rows data to EF
This is how to do it in LabTalk...
copy -b 1 col(A) col(C) -b 1 -e n; // copy 1st n rows from A to C
copy -b 1 col(B) col(D) -b 1 -e n; // copy 1st n rows from B to D
n1=n+1;
n2=N-n;
copy -b n1 col(A) col(E) -b 1 -e n2; // copy last N-n rows from A to E
copy -b n1 col(B) col(F) -b 1 -e n2; // copy last N-n rows from B to F
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 04/21/2005 12:10:08 PM
Edited by - Mike Buess on 04/21/2005 1:21:39 PM |
| Younger2008 |
Posted - 04/21/2005 : 10:54:56 AM
But sometimes I want to extract the certain amount of the data to new columns in the same worksheet, how to do this?
For example, a worksheet with A,B,C,D,E,F 6 columns. The first two columns A and B were stored N rows original data. How to extract the first n rows data from AB to CD, and the rest (N-n) rows data to EF, and something like this.
Thanks. |
| Mike Buess |
Posted - 04/21/2005 : 07:26:36 AM
1. Choose Analysis > Extract Worksheet Data
2. Enter this condition... col(1)[i]==2
3. Click "Do it"
Mike Buess
Origin WebRing Member |
|
|
