Trimming text

0
Good Morning,   Is there a way to trim text so there are no unnecessary spaces but to still allow to have text starting on new lines.   In the below example in the text field, 4 notes are put on different lines but on the home page they are showing on one line which doesn’t look very good. The trim formula used is below.   Can anyone guide me please?         Thanks   Jess
asked
2 answers
2

You replace all whitespace characters (which includes newlines) with a space. Try '[ \t]+' instead of '\s+', which will replace all spaces and tabs with a space.

answered
0

Thank you, it is allowing me to have the new lines now however it no long removes unnecessary spaces between words on a line. Examples below.

 

The formula I am now using is also below. 

 

 

Thank you for your help.

 

Jess

answered