| Author |
 Topic  |
|
|
vccer
Malaysia
4 Posts |
 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 |
|
|
greg
USA
1379 Posts |
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.)
|
 |
|
|
Mike Buess
USA
3037 Posts |
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 |
|
|
| |
Topic |
|
|
|
Multiple asci file import, filename append to col