| T O P I C R E V I E W |
| vccer |
Posted - 02/06/2004 : 10:44:46 PM
Dear all,
I have massive asci datasets that need to be import. Only y values are needed. Also, how can I append the filenames to these col. The filenames are actually very long 20 alphabets, can this be possible? If not, can I say start from the 10th character? I am using origin 7.0, awaiting my 7.5 version.
Thanks,
SS |
| 2 L A T E S T R E P L I E S (Newest First) |
| Mike Buess |
Posted - 02/09/2004 : 12:35:26 PM
You can retrieve the last 10 characters of the file path\name like this...
%A=page.label$;
%A=%[%A,>%[%A]-9]; // last 10 characters
wks.col2.name$=%A;
Periods aren't allowed in a column name so you may need to get rid of the extension first...
%A=page.label$;
%A=%[%A,'.']; // up to extension
%A=%[%A,>%[%A]-9]; // last 10 characters in remainder
wks.col2.name$=%A;
Mike Buess
Origin WebRing Member |
| greg |
Posted - 02/09/2004 : 10:31:47 AM
With Origin 7.5 you will be able to use features of the Import Wizard, but for 7.0 you can use Partial Import to get just the Y values using the Import ASCII dialog or with a script, like:
http://www.originlab.com/www/support/resultstech.aspx?ID=894&language=English
The ASCII Import puts the full path and filename in the Worksheet label which can be accessed by:
%A = page.label$;
Then you can use %A and put it anywhere that can accept longer strings (NOT worksheet Name and NOT column Name.)
|
|
|
