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!
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
Sorting data according to partial sheet name
Posted - 12/21/2020 : 03:40:27 AM
