cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
itsmeqp
Level: Powered On

Concatenating Column Values to String

I am looking for a way to concatenation/join the values of a column from a table to generate a single string of text

 

Say I had a collection with 3 values in column Result:

 

Result

  • dog
  • cat
  • bird

 

I would like to concatenate those values and using semi-colon as a delimiter to create a text value of dog;cat;bird;

 

I tried using Concat and ForAll but can't seem to find a way to make it work.

1 ACCEPTED SOLUTION

Accepted Solutions
itsmeqp
Level: Powered On

Re: Concatenating Column Values to String

5 REPLIES 5
itsmeqp
Level: Powered On

Re: Concatenating Column Values to String

danherring
Level: Power Up

Re: Concatenating Column Values to String

I can't access this link! How did you do it!!??

itsmeqp
Level: Powered On

Re: Concatenating Column Values to String

Antonima
Level: Power Up

Re: Concatenating Column Values to String

Concat([your table], [your column] & ";")

Charles_Haines
Level: Powered On

Re: Concatenating Column Values to String

How do I do this if I don't have any columns?
I have a string "1,2,3,4,5"

I used split to get it into a collection to display in a lisbox. 
Set(itemNumbers, TrimEnds( Split( gallery.Selected.ItemNumbers, ",") ))
I later want to get all the selected items back into a new flat string. Ex: "1,2,5"

How can I do this?