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

#1

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?

0 Likes

#2

Never mind all sorted - I didn’t think.
I had applied linebreaks to the 3rd table… Sorry about this question.

0 Likes

#3

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