| T O P I C R E V I E W |
| osumse |
Posted - 04/30/2004 : 5:21:46 PM
I have the following data calculatd by a certain software:
---------------------
B(0.629727)+L(0.278031)+D(0.0922417)
B(0.621733)+L(0.288018)+D(0.0902492)
B(0.613374)+L(0.298439)+D(0.0881877)
B(0.604624)+L(0.309323)+D(0.0860531)
B(0.595458)+L(0.320701)+D(0.0838408)
B(0.585845)+L(0.332609)+D(0.0815461)
B(0.575755)+L(0.345082)+D(0.0791635)
B(0.565151)+L(0.358162)+D(0.0766872)
.....
---------------------
I want to plot the above three colum values as x, y and z axis. but i do not know how to import such kind of data into Orgin. Although i can do it by hand, but I have thousands of such data everyday. It is nearly impossible to do that.
Do you have any method?
thanks
|
| 1 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 05/01/2004 : 08:51:55 AM
You can do this easily with a worksheet template. Start with a blank worksheet.
1. File->Import->ASCII Options
File Structure...
Delimiter: Other +
(all else unchecked)
File Header...
Skip main header, # lines: 0
Specify known subheader lines: 0
# of Columns... 3
Import as... New data
Other options... All deselected
Select Update Options
2. Tools->Worksheet Script
Run script after: Import
Select Update after entering the following script...
get col(1) -e npt;
loop (i,1,wks.ncols) {
loop (j,1,npt) {
%A=cell(j,i)$; // get cell value as string
%A=%[%A,>3]; // extract substring starting with 3rd character
cell(j,i)=%[%A,')']; // extract substring ending before ')' and assign to cell as number
};
wks.colSel(i); // select column
};
wo -p 240 3D; // plot as 3D Scatter - see LabTalk's worksheet command for other plot types
3. (Optional) Change column names to B, L and D.
4. Set third column as Z.
5. File->Save Template As... give it a name
6. File->Import ASCII... try it out
Hope that helps,
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 05/01/2004 09:17:58 AM |
|
|
