Solved

sharepoint 2007 workflow change data in a field

Posted on 2014-10-14
2
214 Views
Last Modified: 2014-10-20
i am new to sharepoint workflows so thank you for your patience. i am using sharepoint 2007

1) data in field from external source ( ie   1;#1234 , 2;#5678 )
2) i want to take the data in the field and remove the first three characters and keep the remaining and then copy the data to a second field. so if the data in the field was "1;#1234" it would remove the first three characters no matter what they were "1;#" and place "1234" to the next field. if the data was "2;#5678" it would remove the first three characters no matter what they were "2;#5" and place "5678" in the next field.
dont worry about the " that is what i did to say what the data is.

thank you for your help
0
Comment
Question by:metatonka
2 Comments
 
LVL 15

Assisted Solution

by:colly92002
colly92002 earned 250 total points
ID: 40381791
Ideally you would use a string function (left, right, trim etc) to do this.  Unfortunately MOSS workflows do not offer these OOTB.

Fortunately somebody has created a codeplex project specifically to add this functionality:
http://blog.summitcloud.com/2009/12/string-building-expressions-in-sharepoint-workflows-with-sq/
Discussion:
https://social.msdn.microsoft.com/Forums/en-US/3f4f7ff2-0596-40c5-adff-2ae326dd2d98/string-functions-in-workflow-stringbuilder?forum=sharepointcustomizationlegacy


Alternatively you could use a calculated column on your list to to do this with this formula (off the top of my head):

=RIGHT(FieldName, 3)
0
 
LVL 9

Accepted Solution

by:
macarrillo1 earned 250 total points
ID: 40385140
I agree with colly92002.
Although, I personally would use the calculated column.
So if you have a column named Field1 (that contains 1;#1234)
then create a calculated column (Field2) with the formula (mentioned above):

=RIGHT(Field2, 3)

Then use the calculated column (Field2) in the workflow.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
For SharePoint sites, particularly public-facing ones, there are times when adding JavaScript, Meta Tags, CSS Styles or other content to the page <head> section is more practical than modifying master pages.  For instance, you could add the jQuery l…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

816 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now