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 , Country Compliance Forms , How To