Removing Ending Text with Expression

[djnguyen]

I have written an Expression that combines the text using semi-colons as a delimiter.

CONCATENATE([#1 - Package], "; ",[#2 - Package], "; ", [#3 - Package], "; ", [#4 - Value], "; ", [#5 - Package], "; ", [#6 (Custom) - Package])

However, the only flaw here is that not every "package" is going to be filled out so if I only have 3 packages submitted, then my text would have a bunch of semi-colons at the end.. is there a way to rework this expression so that I do not have any trailing semi-colons.

[Marc_Dillon · Accepted solution]

LIST( [col1] , [col2] , ... ) - LIST("")