Extra spaces at all

Hi folks!

I have this formula:

CONCAT($A," “,$B,” ",$C)

When I don’t have a value for $B, the result is an extra space between $A and $C

There is any way to remove it?

Thanks in advance!


You could use a conditional:

if $B != '':
  CONCAT($A," ",$B," ",$C)
  CONCAT($A," ",$C)

Beautiful! Thanks!

But I need a “return” somewhere?

Oh, right. I tested it, realized I needed to put in returns, put in the returns when I was testing, and then forgot to update the code here :man_facepalming:

if $B != '':
  return CONCAT($A," ",$B," ",$C)
  return CONCAT($A," ",$C)

Thanks! I got this:

if $infraspecificEpithet != '':
 nome= CONCAT($genus," ",$specificEpithet," ",$taxonRank," ",$infraspecificEpithet," ",$scientificNameAuthorship)
 nome= CONCAT($genus," ",$specificEpithet," ",$scientificNameAuthorship)
return nome
1 Like