The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Rows selection with a specific step

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
ado44 Posted - 02/10/2020 : 1:26:45 PM
Hi everyone,

Here is my problem: I want to do an ACP. To select variables I want to select rows between 1 and 100000 with a step of 25000 (for example, so I should have the row number 1, 25000, 50000, 75000 and 100000).
How should I write it in the variables box? ...[1:25000:100000] or else?

Thank you very much for your reply and help.
1   L A T E S T    R E P L I E S    (Newest First)
cpyang Posted - 02/10/2020 : 2:18:09 PM
you can use the X-Function wxt, like

wxt test:="i==1||mod(i,2500)==0" sel:=1;


Please note that the condition expression must be standard Labtalk notation, while the Worksheet Query dialog you can use more relax notation like "i=1 or mod(i,2500)=0", which is a good place for you to test the condition, then write it out in the more strict form in script.


CP

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000