Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2079
  • Last Modified:

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

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
dgmoore1
Asked:
dgmoore1
  • 2
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
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
 
dgmoore1Author Commented:
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
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Don't think you can. String manipulation in SPD workflows is on my wishlist, too! :-))

cheers, teylyn
0
 
dgmoore1Author Commented:
Not the answer I wanted to hear, but useful information nonetheless.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now