Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 06, 2019 03:24 AM
I’m looking up some text from a different table (Which is another look up from a 3rd table).
But the look up creates stacked text (I’ve expanded the length of the field - but still stacked)
Is there a way to get rid of all these line breaks and make the text all on one line?
Mar 06, 2019 03:26 AM
Never mind all sorted - I didn’t think.
I had applied linebreaks to the 3rd table… Sorry about this question.
Mar 06, 2019 04:45 AM
For any future readers looking over our shoulders, if you do need to remove linebreaks from a text field, you can use this to do so:
SUBSTITUTE(
{Text},
'\n',
' '
)
Depending on your source text, that might result in some doubled spaces — if a line of text ends with a space followed by a linebreak, for instance. If so, wrap the preceding formula in another SUBSTITUTE()
function and clear out the extra spaces:
SUBSTITUTE(
SUBSTITUTE(
{Text},
'\n',
' '
),
' ',
' '
)
Dec 28, 2022 11:04 PM
Unfortunately this will remove any formatting.
Any chance a script could be made to solve this?
Mar 02, 2023 09:34 AM
Awesome! That worked for me! ✨