Item separator by a line break from select statement

[richard_s]

Hey folks, is there any way of separating text values by line break from list select statement? I want the items in the virtual column called test to be separated by line breaks as it is in the second picture. I also need these items to be separated by new lines in my generated word document so that’s why I’ve created the extra virtual test column. Thanks!

→

[Steve · Accepted solution]

Like this:

SUBSTITUTE(SELECT(...), ",", "
")

Note carefully that the first line ends with a quote mark and the second line begins with a quote mark. The second line should not be indented–it should be flush against the left edge of the expression-editing window.

See also:

help.appsheet.com

SUBSTITUTE()

Text with replacements

[richard_s]

It works great, thank you for your quick response Steve!

[Stephen_Ehmann]

If SELECT returns a list, why do we need to substitute a string?  shouldn't the separator setting in the virtual column take effect?

I am also facing this issue and when I use the test feature on the virtual column formula, it gives me what I would expect with my separator.  But if I display this column in a detail view, it shows the default , separation.  Seems like a bug.

Of course as a workaround I can use this substitution or I can maybe try a JOIN list to text with delimiter equivalent expression (posted about this separately)

[Suarezdelrio]

As you explain @Steve , it works fine in the virtual column... but when I create the DOC I have the same problem again, and it's all on the same line.
Do you know how I could fix this?
Thank you so much!

[Steve]

Please post a screenshot of the document template that shows the part that isn't working.

[Suarezdelrio]

Thanks so much @Steve, I solved it reading other post from you!

[dbaum]

In case it's helpful, @Suarezdelrio: Concatenate values with a delimiter: How to simula... - Google Cloud Community . 

[Migo]

Which post that solved the issue of the DOC output

@Suarezdelrio