Concatenate fields without leading spaces

[KAPITYAN]

I want to concatenate values even if the first or second is blank. In such a way that there are no left over spaces if one is null. So I am trying to combine FirstName1 + LastName1 + FirstName2 + LastName2, and if Name 1 is blank, I prefer not to have any leading spaces in my result. Is it possible?

[NailDyanC]

You may try this formula:

CASE WHEN
[@field:FirstName1] = ' '
THEN
IsNull([@field:LastName1], ' ') + ' ' + IsNull([@field:FirstName2], ' ') + ' ' + IsNull([@field:LastName2], ' ')
WHEN
[@field:LastName1] = ' '
THEN
IsNull([@field:FirstName1], ' ') + ' ' + IsNull([@field:FirstName2], ' ') + ' ' + IsNull([@field:LastName2], ' ')
WHEN
[@field:FirstName2] = ' '
THEN
IsNull([@field:FirstName1], ' ') + ' ' + IsNull([@field:LastName1], ' ') + ' ' + IsNull([@field:LastName2], ' ')
WHEN
[@field:LastName2] = ' '
THEN
IsNull([@field:FirstName1], ' ') + ' ' + IsNull([@field:LastName1], ' ') + ' ' + IsNull([@field:FirstName2], ' ')
END

 

Just change the fields that I usedepending on the fields that you are using. I hope that helps you.

 

[KAPITYAN]

Thank you, @NailDyanC.  I need to translate this into a Caspio 'Task' or Triggered Action. Would it be possible to show an example in that format for me to use as a guide?

[NailDyanC]

Hi @KAPITYAN, you may try this sample trigger.

[Barbie]

Hello, 

You may want to check and watch these articles for more information and better visualization in Tasks and Triggers: 
https://howto.caspio.com/tasks/
https://howto.caspio.com/tables-and-views/triggered-actions/

 

- Barbie