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 for Programming
 LabTalk Forum
 Sorting data according to partial sheet name

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
onoseque Posted - 12/21/2020 : 03:40:27 AM
Origin Ver. 2021
Operating System: Windows
I am batch processing peaks and want to sort the data according to partial sheet name:
each sheet has a name with format i.e 18_80_P were the first number (18 in this case) is the number of hours. So I batch process the peaks and then do a first sorting of the data with wunstackcol. Then I would need a second sorting according to the partial sheet name (the number of hours), which is now in the column data set Id. But I can't find how to call a partial name. Any help?
Thanks!
3   L A T E S T    R E P L I E S    (Newest First)
Chris D Posted - 12/22/2020 : 09:19:25 AM
Replace the F(x)= I gave you with:

gettoken(gettoken(A,1,"_"),2,"]")


Where A is the Id column.

Thanks,
Chris Drozdowski
Originlab Technical Support
onoseque Posted - 12/22/2020 : 03:33:16 AM
Hi Chris,
many thanks! that nearly nearly got the issue. Now I have the book name in the way (so the id looks like [A9080Pe]66_80_E-a!(A"Wavelength",D"Normalized1") and then I get [A9080Pe]66 but I need the 66 only. I would much appreciate your support.
Thanks again!



You can try this (unless I misunderstood you):

1. Add another column to sheet.
2. for the new column, set the F(x)=

gettoken(A,1,"_")

replacing A with the column letter for the Id column.
3. Now sort the worksheet based on the new column.


Thanks,
Chris Drozdowski
Originlab Technical Support

[/quote]
Chris D Posted - 12/21/2020 : 08:32:49 AM
You can try this (unless I misunderstood you):

1. Add another column to sheet.
2. for the new column, set the F(x)=

gettoken(A,1,"_")

replacing A with the column letter for the Id column.
3. Now sort the worksheet based on the new column.


Thanks,
Chris Drozdowski
Originlab Technical Support

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