Not applicable
2010-11-09
12:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set Variable to a Formula via Action
I am trying to set a variable to a formula (i.e., beginning with an equal sign) via an action trigger.
I was able to successfully set a variable to call the =OSUser function by setting the action to assign its value as ='=OSUser()'
However, I can't seem to make this "style" of a formula setting work if the formula itself has quotes in it.
Example:
='=''test'''
Any suggestions???
3,769 Views
1 Solution
Accepted Solutions
pover
Luminary Alumni
2010-11-09
01:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
567 Views
2 Replies
pover
Luminary Alumni
2010-11-09
01:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use chr(34) like the following:
='='&chr(34)&'test'&chr(34)
Regards,
568 Views
Not applicable
2010-11-09
02:21 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you very much. FYI, I needed to use chr(39) instead of 34 but it worked great!!!
567 Views