Splitting Strings in SuccessFactors Business Rule

[MSTan]

Introduction

SuccessFactors Business Rule does not provide a direct split function when it comes to manipulating strings, such as splitting a string into multiple parts based on a delimiter. Instead, organizations can use a combination of string manipulation function like indexOf() and substring() to achieve the expected outcome.

Use Case: Splitting a String into Multiple Variables

Scenario

An organization has created a custom MDF object with the external code such as text1-text2-text3-text4, where each part of the string represents a specific attribute (e.g. Department, Location, Pay Grade, Employee ID). The organization needs to split this string into 4 separate variables for further processing.

Step-by-Step Implementation

1. Define the 4 variables field in custom MDF object:

2. Create a Business Rule, set purpose as Evaluate.

3. Assign the Business Rule to the field externalCode in the custom MDF object.

4. Test Solution - Create a new data for custom MDF object.

Click Enter, the values of variant1-variant4 are automatically populated.

In some cases, the input string may not always have the same number of parts. For example, the string might have fewer delimiters, such as text1-text2. The solution handles such cases gracefully.

Conclusion

By leveraging functions like indexOf() and substring(), organizations can handle complex string formats and derive meaningful insights from their data. 

[xavierlegarrec]

Really cool, thanks for sharing !