Help

Concatenate "eats" my separators inside the fields

Topic Labels: Formulas
6566 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Penny_Schiffer
4 - Data Explorer
4 - Data Explorer

Hi all, I would like to combine two text fields into one. Each field has several entries that are separated with a comma (e.g. in one row field 1 contains “Germany, EU, France” and field 2 contains “Italy, Austria”).

When I combine them with {Field1} & {Field2} it deletes all the commas so that it looks like this: “GermanyEUFranceItalyAustria”. How can I keep the commas and just combine the field`s text exactly like it is? Tried already joinarray and putting using {Field1} & ", "& {Field2} but still the same effect.

Thank you!

10 Replies 10

Could you please share your existing formula, and describe in greater detail some example content of all the fields you’re trying to combine?