Line Breaks in Mode Tables?

Is there a simple way to add line breaks into the displayed output of a Mode table?

i.e. something like:

CONCAT(string_one, "</br>", string_two)

and have it display as:

string_one

string_two

Thanks!

Matt

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hi Matthew !  

    Not sure which database you're using but here's how you can do it PostgreSQL.

    In the SQL use chr(10) for the line break:

    SELECT CONCAT('test line 1', chr(10), 'test line 2')
    

    Then in your report's CSS use this:

    <style>
      .mode-table-grid td {
        white-space: pre;
      }
    </style>

    Let us know how that works for you!

    Reply Like
  • ah, great idea! Unfortunately we're using BigQuery SQL, which doesn't seem to support these character functions.

    Is there anyway to get the table to recognize and render HTML tags within cell values?

    Reply Like
  • I'm sorry but Mode's Display Tables won't render HTML (e.g. <br>) at the moment.    

    Reply Like
login to reply
Like1 Follow
  • 1 Liked by
  • 2 mths agoLast active
  • 3Replies
  • 85Views
  • 2 Following

Create A New Discussion

Share your thoughts