How do I remove empty lines from a text block

Ask for Help
1

I have a text block that collect “warnings” incase my user has forgotten something.
The block is made with a template column that takes a bunch of inputs some IF-Else columns.
The idea is to have a neat little list of actionable suggestions for the user to act on.

However when certain conditions in is satisfied and no text is shown it leaves a blank line in my list - is there a way to get rid of these blank lines?

I tried the replace text column but that didn’t work, and trim whitespace only trims in the start and end of the text.

Screenshot 2023-06-22 at 21.11.45
Screenshot 2023-06-22 at 21.11.451026×778 65 KB

2

You could try putting the carriage returns in each IF column result instead of the template column. Then remove the carriage returns from the template column.

3

Or use a Make Array column to combine the ITE columns and then a join text column to join the Array by a carriage return. The Make Array column will ignore blank array values so they’ll never have their own line.

4

Thank you both @Jeff_Hager and @Robert_Petitto.

Went with the array solution and works perfectly.