Skip to main content

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?

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


        ' '


        ),


    '  ',


    ' '


    )

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?

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


Terms & Conditions