Extra spaces

[Kuroshi]

I have an issue in my current workflow. If the first field(Prefix such as Mr. Mrs. Ms) is blank, space appears before the first name when the formula is displayed.

Is there another formula that will eliminate the blank space if field 1 is blank? Here is the formula that I'm currently using: (SELECT [@field:Prefix] + ' ' + [@field:FirstName] + ' ' + [@field:LastName] 

[Barbie]

Hi @Batchini,

You may want to check this formula:

 

isnull([@field:Prefix],'') + (case when [@field:Prefix] = ' ' then '' else ' ' end)+ isnull( [@field:FirstName],'') + (case when [@field:FirstName] = ' ' then '' else ' ' end) +  isnull( [@field:LastName],'') + (case when [@field:LastName] = ' ' then '' else ' ' end))

I hope this works. 

Regards,
Barbie

[NailDyanC]

Hi @Batchini

You may also try this formula:
CASE WHEN
[@field:Prefix] = ' '
THEN
IsNull([@field:FirstName], ' ') + ' ' + IsNull([@field:LastName], ' ')
ELSE
[@field:Prefix] + ' ' + IsNull([@field:FirstName], ' ') + ' ' + IsNull([@field:LastName], ' ')
END

[Barbie]

In addition to the response above, you may refer to this article for more examples and function explanations: https://howto.caspio.com/function-reference/

- Barbie