Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to get rid of unwanted linebreak when looking up text?

1832 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

3 Replies 3

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',
        ' '
        ),
    '  ',
    ' '
    )

Unfortunately this will remove any formatting.
Any chance a script could be made to solve this?