Join strings in a list

[skankhunt42]

I want to join all the strings in a list.

Example: List1= {"Apple","Banana","Carrot"}

Expected result:

Apple

Banana 

Carrot

When I use concatenate it is giving me Apple,Banana,Carrot

 I want each of my items to be in new line with out comma. Please help 

[Austin_QREW]

Hi @skankhunt42 ,

Great Question!

Try this: 

"Apple" & "
" &
"Banana" & "
" &
"Carrot" 

 The & symbol functions as the CONCATENATE() function in AppSheet. Hope this helps let me know if you have any other questions.

Thanks,

Austin from AppSheet Training

[Stephen_Ehmann]

I don't believe this answers the original question, how can a list be joined into a string with a delimiter.  the answer cannot hardcode the contents of the example list as the solution?  Please elaborate on a general solution to handle a list where the length and content is not known at the time the expression is being written.  It's baffling to me that there is no JOIN function in appsheet to go along with the SPLIT function.

[Steve]

Please start a new topic for help with this.