Hi ivydong,
Perhaps you can send your analysis template to support and we can take a look? You can use the "Send File to Tech support" link on the top of this page, and then refer to this post in your message.
Another solution is the following:
1> Do not worry about extracting file name in your filter etc - just import the data and set up the analysis template for your operations
In the Batch Processing tools, after you pick all the files you want to process:
2> Set the Dataset Identifier drop-down to File Name, this will add a 1st column in the Output sheet which will have the file name with the extension.
3> In the same dialog, expand the Script branch, and in the "Script at the End" edit box, enter this script:
range r1=1;
for(int ir=1; ir<=r1.GetSize(); ir++)
{
str$ = r1[ir]$;
r1[ir]$ = str.GetFileName(1)$;
}
r1.format=1;
Then at the end of the batch processing task, the script will run automatically and convert the 1st column by stripping off the extension and also converting the column to type numeric.
Easwar
OriginLab
Import file name as variables without extention
Posted - 02/25/2013 : 9:57:17 PM
