Solved

sharepoint 2007 workflow change data in a field

Posted on 2014-10-14
2
219 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: 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!

Question has a verified solution.

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

Suggested Solutions

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

734 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