In SPD workflows, under Actions, there is a set of Utility functions.
Using the substring function, a string can be trimmed from the beginning/end/or from a position, with or without specifying the length.
An example, to remove the domain part from the user name, e.g. abcdomain/username, follow the below steps
1. Use “Extract substring from the index of string”
2. It would insert a step in WF as “Copy from string, starting at 0 (Output to Variable: substring)
3. Click on ‘string’ and click fx to get the field to be trimmed.
4. It would bring the look-up window.
5. Select the field and click OK. In this e.g., Data Source: Current Item and Field from Source: Created By
6. To set the index, click on 0 and enter the required number, here it would be 11.
7. If the variable name has to be changed, click on ‘Variable:substring’ and change the name.
8. The value stored in the workflow variable would be ‘username’
The workflow variable can be used in further steps in the workflow as required.
To get the workflow variable, in the Lookup for string window, for Data Source – select Workflow Variables and Parameters
The other string functions available are
· Extract Substring from Start of String
· Extract Substring from End of String
· Extract Substring of String with Index of Length
· Find Interval between Dates
What if i want to find index of string for example,
ReplyDeleteI have current item field with value "abc#def", '#' character index will be dynamic there can be any number of characters before and after '#' character in string. So in that case i will require '#' index and need to extract string after'#'.