|
Mike Buess
USA
3037 Posts |
 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 |
 |
|
import data problem
