Concatenating dynamic data

I can concatenate dynamic data to display by putting a space between elements e.g.

User’s First Name<space>Users Last Name

but if I concatenate strings that may be empty I get too many spaces e.g. where User’s Middle Name is optional so may be empty:

User’s First Name<space>User’s Middle Name<space>Users Last Name

I’ll end up with the following displayed:

User’s First Name<space><space>Users Last Name

Is there a way to prevent this?

You can check if the string is empty first, then use :formatted as text operator to output the text or nothing.


1 Like