SAP Knowledge Base Article - Public

3691259 - How to split a field containing spaces into two separate fields?

Symptom

The employee's last name consists of two words, separated by a space. How can we divide this last name and place each word into separate fields?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

 

Environment

SAP SuccessFactors Employee Central

  • Personal Information
  • Business Rule

Resolution

Create a business rule as below. 

It could be configured as onChange rule under Manage Business Configuration<personalInfo<last-name field.

Base object of the rule could be:

  • Employee Information Model, which could be triggered for new hire process only
  • Personal Information Model, which could be triggered for both new hire and existing employee.

The variable is used to obtain the index of the space, as there is no built-in function to directly identify space.

Keywords

add new employee, personal information, two lastnames, onChange , KBA , LOD-SF-EC-HIR-RUL , Business Rules , Problem

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Core all versions ; SAP SuccessFactors HCM Suite all versions