| T O P I C R E V I E W |
| wallacej |
Posted - 05/23/2005 : 06:01:03 AM
Origin Version (7.5):
Operating System: win2k
I currently use the following line of script to retrieve elements 4 and 5 of the data in cell at column 10 of row 1.
%K = %[%(sheet1, 10,1),4:5];
The data in the cell has now changed and has some user inputted text at the beginning. This text can be of variable length which means that the elements I wish to retrieve are no longer in the set positions of 4 and 5.
My plan is to retrieve the data elements by using their position from the end of the value, as opposed to the beginning. Is it possible to do this in lab talk? Or do I have to put the value of the cell into a variable and perform some manipulation using C?
Thanks in advance
|
| 2 L A T E S T R E P L I E S (Newest First) |
| wallacej |
Posted - 05/23/2005 : 12:06:28 PM
Thanks Mike
Worked a treat!
Wallace
|
| Mike Buess |
Posted - 05/23/2005 : 07:36:25 AM
The length of string %A is given by %[%A]. Either of these expressions will get the last two characters of %A...
%K=%[%A,%[%A]-1:%[%A]];
%K=%[%A,>%[%A]-1];
Mike Buess
Origin WebRing Member |
|
|
