All Forums  Origin Forum for Programming  LabTalk Forum  Conditional extraction of cells in a new column

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

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by fabiolucared[/i] [br]Origin Ver. and Service Release (Select Help-->About Origin): 9.4 Operating System: Windows 10 Hi, I managed to import a txt file with the impasc function. I am now trying to make evaluation on the data. A typical file looks like this: T I Z N 2 5 1 5 1 5 1 1 6 5 1 3 2 5 2 4 3 5 3 8 4 5 3 9 6 5 4 7 I would like to split the worksheet according to the Z number, therefore: if(Z==1) copy the values of T and N in a new sheet in col(A) and col(B) giving them the names T1 and N1. if(Z==2) copy the values of T and N in the same sheet, now in col(C) and col(D) giving them the names T2 and N2. And so on for Z=3 and Z=4. The number of rows is not always the same, therefore I need a conditional. I tried with the wxt function but this always copied all the columns (also the ones I do not want) and it created always a new sheet instead of placing them in new columns of the same sheet. A nice way which I could do manually was the "Worksheet query" where the conditions (for example Z==1) can be assigned to a column and can be recalculated everytime. Is it possible to make this (conditional query) with a LabTalk script (since often Z>100)? Thanks in advance for every advice. Fabio [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.