Help

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

1321 2
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?

4 Replies 4

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?

Awesome! That worked for me!