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?
Never 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',
' '
),
' ',
' '
)
W_Vann_Hall wrote:
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',
' '
),
' ',
' '
)
Unfortunately this will remove any formatting.
Any chance a script could be made to solve this?
W_Vann_Hall wrote:
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',
' '
),
' ',
' '
)
Awesome! That worked for me! ✨
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.