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))

?
dgmoore1Asked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.