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

Question

Question

Concatenate of text results in extra zeros

Forms Version 10
Updated October 3, 2019
asked on October 1, 2019

Can anyone help me figure out how to get this CONCATENATE action to NOT add extra zeros?

In my hidden collection field:

=CONCATENATE(INDEX(Tree_Orders.Coniferous_2,ROW()),"",INDEX(Tree_Orders.Tall_Deciduous,ROW()),"",INDEX(Tree_Orders.Shrubs_1,ROW()),"",INDEX(Tree_Orders.Special_Order,ROW()))

Results (none of the zeros should be there):

0 0

Answer

SELECTED ANSWER
replied on October 2, 2019

It appears the 0 are coming from the field values in the table. Do the Table fields have default values when not selected?

An option would be to add the following to your equation to replace the 0 characters with no characters.

=SUBSTITUTE(CONCATENATE(INDEX(Tree_Orders.Coniferous_2,ROW()),"",INDEX(Tree_Orders.Tall_Deciduous,ROW()),"",INDEX(Tree_Orders.Shrubs_1,ROW()),"",INDEX(Tree_Orders.Special_Order,ROW())),"0","")

0 0
replied on October 3, 2019

Awesome, Steve!  That worked!  Thanks!

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 ...