Join multi-line text field to one line
Hi all. I'm trying to find a way (either using a formula or in Pipelines) to join a multi-line text field to a single line. Use case: The multi-line text field will contain text that will go to th...
Forum Discussion
It could be any string that has multiple line breaks/spaces, and I need it to be converted into a single line without any line breaks. For example
"blue
green
yellow"
Convert to
"blue green yellow"
line breaks are identified as \n . So you need to use jinja to replace \n with ' '.
from QuickBase page
Return a copy of the value with all occurrences of a substring replaced with a new one. The first argument is the substring that should be replaced, the second is the replacement string. If the optional third argument count is given, only the first count occurrences are replaced:
{{ "Hello\nWorld"|replace("\n", "") }}
output: Goodbye World
{{ a.myfield | replace('\n', '') }}