Saving Colllection or Gallery Control values in to Label

[Sal]

I have one Gallery Control with Items or I can also have one Collection column with values, How can I move all of the values to Label Control to display using Concatenate?

Let say I have one Column in CollectionA call Column1, with values 1, 2, 3. In the Label control I want to display them like 123. How can I do that?

 I tried this expressoin Concat(collection1,col_name & """OR""") and output coming like this 1"OR"2"OR" , I need it in this format "1"OR"2"OR"3"

[Sal]

I want the values in this formate

"1" OR "2" OR "3"

[timl · Accepted solution]

Hi @Sal

This formula should carry out what you want.

Replace(
  Concat(collection1,"""" & col_name & """ OR "),
  Len (Concat(collection1,"""" & col_name & """ OR "))-3,
  4,
  ""
)

The purpose of the Replace function is to remove the trailing "OR". Perhaps someone here might be able to suggest a more elegant solution.

[Sal]

Thanks, I created formula like that below, that is working for me for now to display ("1"OR"2"OR"3") but I will try your suggestion as well.

Mid(Concatenate("""", Concat(collection1, col_name & """OR""")),1,Len(Concatenate( """", Concat(collection1, col_name & """OR""")))-3)

Thanks alot.

-Sal