• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2160
  • 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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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