| T O P I C R E V I E W |
| AKazak |
Posted - 01/27/2022 : 01:00:47 AM
OriginPro 2021b (64-bit) SR2 9.8.5.212
Operating System: Windows 10 x64
Greetings!
Is there a way to use the name of the source worksheet in Preset Result Sheet Name field (https://www.originlab.com/doc/Origin-Help/split-wks-into-sheets?f=dl)?
Thank you.
---
Andrey |
| 6 L A T E S T R E P L I E S (Newest First) |
| AKazak |
Posted - 01/27/2022 : 9:07:28 PM
quote:
Originally posted by snowli
Hi Andrey,
See here about how %[%A, '_']
https://www.originlab.com/doc/en/LabTalk/guide/String-registers
See here about using @SN to get the sheet name.
https://www.originlab.com/doc/en/LabTalk/guide/string-substitution
Actually u can use %(%H, @SN) to get the sheet name of active window %H. So the syntax can be simplified to %(%H, @SN)_%V as well.
Thanks, Snow
Got it!
Thank you.
---
Andrey |
| snowli |
Posted - 01/27/2022 : 1:47:07 PM
Hi Andrey,
See here about how %[%A, '_']
https://www.originlab.com/doc/en/LabTalk/guide/String-registers
See here about using @SN to get the sheet name.
https://www.originlab.com/doc/en/LabTalk/guide/string-substitution
Actually u can use %(%H, @SN) to get the sheet name of active window %H. So the syntax can be simplified to %(%H, @SN)_%V as well.
Thanks, Snow |
| AKazak |
Posted - 01/27/2022 : 11:51:41 AM
quote:
Originally posted by Shirley_GZ
Hi Andrey,
You can try to use the combo substitution notation below as source sheet name:
%([%[%A,'_']]1,@SN)
Thanks,
Shirley
OriginLab
Originlab Technical Service Team
Great trick --- thank you!
Where does one read about the combo substitution notation?
---
Andrey |
| Shirley_GZ |
Posted - 01/27/2022 : 05:19:02 AM
Hi Andrey,
You can try to use the combo substitution notation below as source sheet name:
%([%[%A,'_']]1,@SN)
Thanks,
Shirley
OriginLab
Originlab Technical Service Team |
| AKazak |
Posted - 01/27/2022 : 03:19:07 AM
quote:
Originally posted by Shirley_GZ
Hi Andrey,
You might only be allowed to use the variables listed there.
If you want to show the sheet name in the result sheet names, you can enter it as arbitrary text directly with the selected variable.
Thanks,
Shirley
OriginLab
Originlab Technical Service Team
Please consider adding a key returning the sheet name or putting the source sheet as the text by default to Preset Result Sheet Name text box.
---
Andrey |
| Shirley_GZ |
Posted - 01/27/2022 : 01:38:23 AM
Hi Andrey,
You might only be allowed to use the variables listed there.
If you want to show the sheet name in the result sheet names, you can enter it as arbitrary text directly with the selected variable.
Thanks,
Shirley
OriginLab
Originlab Technical Service Team |
