Minimum Version Required: 23.01
Pre-Conditions
Required Permission - FusionEdit
Recommended Fusion I/II Certification
Steps
Returns the part of the string between the characters in argument 2 based on the occurence in argument 3.
Syntax
SPLIT_PART(String, Characters, Occurrence)
Arguments
String:
A custom text string or field in Encompass.
Characters:
Usually a single character but can be custom text or a word. This will determine where your string will split.
Occurrence:
A number that that specifies the occurrence of the string and which occurrence the string will be split at.
Example
SPLIT_PART('A.B.C.D','.',2) = B