SAP Knowledge Base Article - Public

2613120 - Modificators - Onboarding 1.0

Symptom

  • How to change date format?
  • How I can modify value to upper case or small case?
  • How else value can be transformed?

Environment

  • SAP SuccessFactors Onboarding

Resolution

In Onboarding application we have some functions (modificators) which help transform existing value to necessary format.

The modificators can be used in forms mapping and in notifications. In this case initial value of the key is not changed. If you use modificators in actions in super admin site, you could create additional key(s) which will contain transformed value.

Please see list of modificators for dates.

Modificator Description Example Initial value After
AddDays Add or diff days from date and return new date. {BirthDate,adddays=2} 1/18/1980 1/20/1980
AddMonths Add or diff months from date and return new date. {BirthDate,addmonths=2} 1/18/1980 3/18/1980
AddYears Add or diff years from date and return new date. {BirthDate,addyear=-2} 1/18/1980 1/18/1978
DateFormat Formats date and time with specified format string. {BirthDate,dateformat=dd/MM/yyyy} 1/18/1980 18/01/1980
DayInWords Gives day of month in words. {BirthDate,dayinwords} 1/18/1980 Eighteenth
DayWithPostfix Gives day of month in words with postfix. {BirthDate,daywithpostfix} 1/18/1980 18th
FormatDate Defines format date modificator. It allows to format date depending on user or account settings. {BirthDate,formatDate=long} 1/18/1980 18-Jan-80

 

Please see list of modificators for strings.

Modificator Description Example Initial value After

CharAt

Extracts character at specified position from argument string.

{LastName,CharAt=1}

Testing

T

Left

Extracts N left characters from a string.

{LastName,left=2}

Testing

Te

LoCase

Transforms value to lower case.

{LastName,locase}

Testing

testing

Mid

Returns a specified number of characters from a string starting from a specified position.

{LastName,mid}

Testing Testing
{LastName,mid=1} Testing
{LastName,mid=1;5} Testi

PadLeft

Returns a new string of a specified length in which the start of the string is padded with spaces or a specified character.

{Padding,padleft=6}

1 "     1"
{Padding,padleft=6;0} 1
PadRight

Returns a new string of a specified length in which the end of the string is padded with spaces or a specified character.

{Padding,padright=6}

1

"1     "

{Padding,padright=6;0} 100000
ReplaceKey

Changes key to a specified key if value stored under original key equals to first modificator argument. If value is not equal to first argument then empty string  is returned.

{FirstName,replacekey=TestFname;LastName} TestFname TestLname

Replace

Replaces all occurrences of specified substring with another string.

{FirstName,replace=TestFirst;Second}

TestFirst

Second

Right

Extracts N right characters from a string.

{LastName,right=2}

Testing

ng

SubstrAfter

Returns the substring of the argument string that follows the first occurrence of the parameter string in the argument string, or the empty string if the argument string does not contain the parameter string.

{LastName,substrafter=ti} Testing ng
SubstrBefore

Returns the substring of the argument string that precedes the first occurrence of the parameter string in the argument string, or the empty string if the argument string does not contain the parameter string.

{LastName,substrbefore=in} TestingLName Test
Substr Return substring from a string.

{LastName,substr=2}

TestLastName estLastName
{LastName,substr=1;4} Test

Title

Capitalize human name.

{Name1,title}

TESTINGNAME

Testingname

TrimEnd

Trims value from end.

{Name2,trimend}

"  Test   "

"  Test"

Trim

Trims value from both start and end.

{Name2,trim}

"  Test   "

"Test"

TrimStart

Trims value from start.

{Name2,trimstart}

"  Test   "

"Test   "

UpCase

Transforms value to upper case.

{LastName,upcase}

Testinglastname

TESTINGLASTNAME

 Other modificators.

Modificator Description Example
ifempty Returns specified string if original value was empty. {Suffix,ifempty={LastName} {FirstName}}
objattr retrieves properties from UserInfo. {user:HiringManager, objattr=email}
{user:HiringManager, objattr=firstname}
currency Return formats currency with specified format string. It returns source value if source value cannot be processed. {Salary1,currency}
{Salary1,currency=0}
{Salary1,currency=1}
{Salary1,currency=2}
ifeq Gets 3 values as parameters. If source value equals first parameter then it gets replaced with second parameter. Otherwise it is replaced with third parameter. {FlagYes,ifeq=Yes;1;0}

 

Modificators can be used as single and can be used together.

Examples:

  • {Salary1,currency=2,substrafter=$} 
  • {MiddleName,charat=1,upcase} 

Keywords

SF, success factors, ONB, OBD, on boarding 1.0 , KBA , LOD-SF-OBD-FRM , Forms, PDF, E-Verify and Compliance Forms etc. , How To

Product

SAP SuccessFactors Onboarding all versions