You are viewing limited content. For full access, please sign in.

Question

Question

Using Concatenate to combine four fields into one; results in zeros when a field is blank.

Forms Version 10
Updated December 10, 2020
asked on December 10, 2020

I am having the same issue as this user, in this post from March 2019, which does not appear to have been answered:  https://answers.laserfiche.com/questions/156149/Zero-0-in-empty-field-being-populated-by-forms-during-a-concatenate-function#156514

  • My formula is:  =CONCATENATE(Employee_Name, NameSeasonalEmployee, Councillor_Name, ASB_MemberName)
  • The result is:     00Connie Prendergast0     (depending on which of the fields were blank)

 

Is there a way to have the zeros not show up?

 

0 0

Answer

SELECTED ANSWER
replied on December 10, 2020

Until they fix the issue Connie, you could do something such as this, assuming 0's were very in the names

=SUBSTITUTE(CONCATENATE(Employee_Name, NameSeasonalEmployee, Councillor_Name, ASB_MemberName),"0","")

0 0
replied on December 10, 2020

Thanks, Steve! That worked!

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...