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
MarkShnier__You
Qrew Legend
Qrew LegendI'm no JSON expert but I know native Quickbase. Can you provide an example of what the data now looks like and what it needs to look like?
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 pageReturn 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', '') }}
