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
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Split Worksheet by Reference Columns: wks name
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

AKazak

Russia
728 Posts

Posted - 01/27/2022 :  01:00:47 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

Shirley_GZ

China
Posts

Posted - 01/27/2022 :  01:38:23 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
728 Posts

Posted - 01/27/2022 :  03:19:07 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

Shirley_GZ

China
Posts

Posted - 01/27/2022 :  05:19:02 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
728 Posts

Posted - 01/27/2022 :  11:51:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

snowli

USA
1031 Posts

Posted - 01/27/2022 :  1:47:07 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
728 Posts

Posted - 01/27/2022 :  9:07:28 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000