How to split a string value into substrings

RunaBase

Administrator
For example, there is a field "Full name", which must be presented in different versions for documents, such as "John Michael Smith" in the document you want to get options "J.M. Smith", "Michael Smith" and others.
To do this, use the Split function for the Composite field.
Function syntax: [Split(Field Name, Separator, Substring number)]
where:
- Field name: field of this object;
- Separator: one or more characters that serve as a separator, such as " " (space);
- Substring number: the number of the substring from the list obtained by separating the original value from the field.
For example, to get the last name from the above example, you must specify a function with the following syntax: [Split(Full name," ",3)]
Function result: "Smith".
 
Top