SuccessFactors Business Rules - concatenate with space

[StephenBurr]

SuccessFactors > Admin Centre > Configure Business Rules

In configure business rules, you can concatenate two fields together using the Concatenate() function.

Is there a way to concatenate 2 fields (lets say first name and last name) with a space in between?

[vbaranovskiy5]

Yes, Stephen!

Use Format() function with Template: %s %s

[StephenBurr]

Thanks Vasiliy!

Bonus question ... is there a way to avoid "null" when one of your arguments is not populated.

So another example might be:

   concatenate first name, middle name and last name

   where middle name might be empty

Stephen + Fred + Burr = Stephen Fred Burr

but

Stephen + <empty> + Burr = Stephen Burr (not Stephen Null Burr)

[vbaranovskiy5]

Just include Null checks in the IF statement of the rule and configure THEN and ELSE variants.