Hi,
Currently you can do this the following way:
Add a new column that is to contain the result, then right click on that column and open the Set Values dialog and then in the Before Formula script enter code such as this:
const nn= _ThisColNum;
range rin= wcol(nn-1), rout= wcol(nn);
for(int ir=1; ir<=rin.getsize(); ir++)
{
string temp$= rin[ir]$;
temp$= temp.mid(2,6)$;
rout[ir]$= temp$;
}
In the above i am assuming the output column is to the immediate right of the input column.
In a future version we will be adding more string processing functions so you can call a suitable function in the top panel without having to write scrit in the bottom panel to loop thru.
Easwar
OriginLab
Extract substring using the set values box?
Posted - 03/02/2009 : 09:09:14 AM
