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?   


Comments

  • 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

    OpenText

     

Sign In or Register to comment.