Solved

Sharepoint 2010 workflow: Substitute field variable in string manipulation function?

Posted on 2013-01-03
4
1,676 Views
Last Modified: 2013-01-04
In a workflow, is there a syntax that can be used to substitute the variable

[%CurrentItem:FieldName%]

for "FieldName" in the function

=RIGHT(FieldName,LEN(FieldName)-FIND("#",FieldName))

?
0
Comment
Question by:dgmoore1
  • 2
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst earned 500 total points
ID: 38742428
Hello,

I don't think you can do string manipulations like that in the dialog. You may need to create a new calculated column in the SharePoint list that stores the value you need in the workflow. Use a calculated column with the formula you posted above.

Note that not all data types can be used in calculated columns.

cheers, teylyn
0
 

Author Comment

by:dgmoore1
ID: 38742433
Thanks - I have already done that, and it works fine, but I was wondering if I could tighten up the process a bit by doing the string manipulation in the workflow instead of using a calculated column.
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
ID: 38742463
Don't think you can. String manipulation in SPD workflows is on my wishlist, too! :-))

cheers, teylyn
0
 

Author Comment

by:dgmoore1
ID: 38743443
Not the answer I wanted to hear, but useful information nonetheless.
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question