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?
How to get rid of unwanted linebreak when looking up text?
+23+23Never mind all sorted - I didn’t think.
I had applied linebreaks to the 3rd table… Sorry about this question.
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',
' '
),
' ',
' '
)
+7For 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',
' '
),
' ',
' '
)
Unfortunately this will remove any formatting.
Any chance a script could be made to solve this?
+2For 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',
' '
),
' ',
' '
)
Awesome! That worked for me! ✨
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.