Welcome and thank you for joining our new OpenText forum. Your questions, responses, best practices, and tips shared with other members will help make this channel vibrant. We're glad you're joining us and look forward to collaborating with you online.

Check out the Getting Started With OpenText Forums for tips on personalizing your experience.

Make a new line from Concat aggregation?

I am trying to create a new line for each " / " I encounter in an aggregated text string. Basically I have a computed column which puts:


Col Label 1      |         Col Label 2                   |    Col Label 3 

John                |    1PM - 4PM/8PM - 12AM    |     someStuff

Alex                 |     9AM - 5PM/                       |     otherStuff

Mary                |    10AM - 4PM/7PM - 9PM    |     herStuff




I want it to  look like:

Col Label 1      |         Col Label 2                   |    Col Label 3 

John                |    1PM - 4PM                         |     someStuff

                             8PM - 12AM    

Alex                 |     9AM - 5PM                        |     otherStuff

Mary                |    10AM - 4PM                       |     herStuff


                               7PM - 9PM    


I have tried adding <br>, /n, cr, \r\n.... etc... nothing seems to help... my concat is always a concat. 


Any ideas?   


  • Hi,


    You should be able to create a computed column like this one:

    row["CUSTOMERNAME"] + "\n" + row["CITY"] + "\n" + row["COUNTRY"]

    and use it in a data item to display data on multiple rows:


    Pierre Richer

    Solutions Consultant, Analytics & Reporting



Sign In or Register to comment.