// Get column count
int ncols = wks.ncols;

// Loop over all Y cols: col 2, 5, 8.....
for(int ic=2; ic<=ncols; ic+=3)
{
   // Use XF to normalize col and place result in a new column 
   rnormalize irng:=$(ic) method:=1 orng:=<new>;
}

quote:

---

Originally posted by easwar

Hello Martin,

Yes, you need a for loop to process all the Y columns.

I am assuming you already know how to set the controls in the multi ascii dialog to bring all files as adjacent columns in same sheet. Then in that dialog, expand the "Scripts" node and paste the following lines of code in the "Script after All Files Imported":

// Loop over all Y cols: col 2, 5, 8.....
for(int ic=2; ic<=wks.ncols; ic+=3)
{
   // Use XF to normalize col and place result in the input itself
   rnormalize irng:=$(ic) method:=1 orng:=$(ic);
}

Then you can click on the black triangle button way at the top right of the dialog and save the settings as a theme. The script will be saved with the theme, so later when you have similar files, you can load the theme from that button and click OK to do the same thing again.

In the above code, I used the rnormalize x-function, as you need to normalize each Y column separately?
https://www.originlab.com/doc/en/X-Function/ref/rnormalize

If your data is XY instead of XYE, then you need to change the for loop to count the Y column positions correctly etc.

Hope this helps.

Easwar
OriginLab

---

// Loop over all Y cols: col 2, 5, 8.....
for(int ic=2; ic<=wks.ncols; ic+=3)
{
   // Use XF to normalize col and place result in the input itself
   rnormalize irng:=$(ic) method:=1 orng:=$(ic);
}