Note: You must be registered in order to post a reply. To register, click here. Registration is FREE!
T O P I C R E V I E W
coll@inia.
Posted - 02/07/2015 : 10:01:21 AM Origin Ver.2015 and Service Release (Select Help-->About Origin): Operating System: win 8
I am trying to extract rows with 4 strings from a worksheet to another new worksheet and give it a similar name to the original wks
The strings are mx*. crp*, psm*, and nitr*. I need them together with all its row data into the same new worksheet
I am trying: wxt test:="col(1)=="mx*"" ow:="Sheet1";
It works fine, except that I cannot make it work simultaneously for all the 4 strings and to the same worksheet. I also have no idea of how to put a similar name into the derived new unique sheet Of course I have many many worksheets!!
can anyone help?
Thanks, julio
5 L A T E S T R E P L I E S (Newest First)
abhishekkhare
Posted - 04/08/2016 : 12:21:54 PM Thanks Hideo, it worked. Thanks for the wcol trick too. Appreciate your quick help.
Abhi
Hideo Fujii
Posted - 04/08/2016 : 10:07:46 AM Hi Abhi,
If windValue and mCol1Ref are scalar values, you don't need $(...) there. As far as I have tried, the following code works:
Posted - 04/08/2016 : 08:26:21 AM Friends, I have the same problem. Want an extract of a sheet based on two conditions. Tried various combination of syntax but no luck. I want my condition like this: