Skip Ribbon Commands
Skip to main content
SharePoint

String Functions

The most common string functions are provided in the table below. In addition the description, syntax, arguments, and an example have all been provided.
 
Function Name                   
Description
Syntax                                                                                
Arguments                                                         
Example                              
Concat
Generates a string concatenation of two or more expressions. This function would be equally beneficial if used to define a rule or a calculation data item.
Concat(string, stringX)
string: an epression
stringX': 2d string to add
Concat("A","B") returns "AB"
Instr Returns the position of the first occurrence of one string within another string. This function would be equally beneficial if used to define a rule or a calculation data item. Instr(string, findString) string: a string
findString: The string to find		 Instr("ABC", "B") returns 1 

Note: The first position is 0, not 1.
Mid Returns a string containing a specified number
of characters from a string.		 Mid(string, start, numChars) string: a string
start: Character position in
string which the part to be
taken starts.
numChars: Number of characters to return		 Mid(DataItem.Example, Largest(InStr(DataItem.Example,";#")+2,0))
Left

Returns the left part of a tring with the given
number of characters.

 Left(string, numChars) string: a string
numChars: integer-numeric
expression indicating how many
characters to return		 Left("ABC", 2) returns AB
Right Returns a string containing a specified number of
characters from the right side of a string.		 Right(string, numChars) string: a string
numChars: integer-numeric
expression indicating how many
characters to return		 Right("ABC", 1) returns C

   
  
Related Topics
Date Functions
Comparison Functions
Math Functions
Bluespring-Specific Functions

Source
BPM Designer Topics > Common Expression Functions
Last modified at 7/31/2020 12:01 PM