• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

sharepoint 2007 workflow change data in a field

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
metatonka
Asked:
metatonka
2 Solutions
 
colly92002Commented:
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
 
macarrillo1Commented:
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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