Skip to main content
Known Participant
May 20, 2008
Question

How to breakup data

  • May 20, 2008
  • 2 replies
  • 226 views
I have a column that contains email addresses, separated by a comma.Some records contain one address, some contain two, others in excess of ten.

When I cfoutput the data into a table, the width of the table has to be 760.But the email column is so wide that it causes the entire table to exceed 760.

How can I breakup the email addresses to be on multiple lines so that the entire table can stay within 760 ?
    This topic has been closed for replies.

    2 replies

    Inspiring
    May 20, 2008
    Normalize your database and you won't have these types of problems.
    Inspiring
    May 20, 2008
    Olivia Crazy Horse wrote:
    > How can I breakup the email addresses to be on multiple lines so that the
    > entire table can stay within 760 ?

    replace(yourEmailAddressData,",","<br>","ALL")