Make a new line from Concat aggregation?
<p>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:</p>
<p> </p>
<p>Col Label 1 | Col Label 2 | Col Label 3 </p>
<p>
</p>
<p>John | 1PM - 4PM/8PM - 12AM | someStuff</p>
<p>
</p>
<p>Alex | 9AM - 5PM/ | otherStuff</p>
<p>
</p>
<p>Mary | 10AM - 4PM/7PM - 9PM | herStuff</p>
<p> </p>
<p> </p>
<p> </p>
<p>I want it to look like:</p>
<p>Col Label 1 | Col Label 2 | Col Label 3 </p>
<p>
</p>
<p>John | 1PM - 4PM | someStuff</p>
<p> 8PM - 12AM </p>
<p>
</p>
<p>Alex | 9AM - 5PM | otherStuff</p>
<p>
</p>
<p>Mary | 10AM - 4PM | herStuff</p>
<div> </div>
<p> 7PM - 9PM </p>
<p> </p>
<p>I have tried adding <br>, /n, cr, \r\n.... etc... nothing seems to help... my concat is always a concat. </p>
<p> </p>
<p>Any ideas? </p>
<p> </p>
<p>Col Label 1 | Col Label 2 | Col Label 3 </p>
<p>
</p>
<p>John | 1PM - 4PM/8PM - 12AM | someStuff</p>
<p>
</p>
<p>Alex | 9AM - 5PM/ | otherStuff</p>
<p>
</p>
<p>Mary | 10AM - 4PM/7PM - 9PM | herStuff</p>
<p> </p>
<p> </p>
<p> </p>
<p>I want it to look like:</p>
<p>Col Label 1 | Col Label 2 | Col Label 3 </p>
<p>
</p>
<p>John | 1PM - 4PM | someStuff</p>
<p> 8PM - 12AM </p>
<p>
</p>
<p>Alex | 9AM - 5PM | otherStuff</p>
<p>
</p>
<p>Mary | 10AM - 4PM | herStuff</p>
<div> </div>
<p> 7PM - 9PM </p>
<p> </p>
<p>I have tried adding <br>, /n, cr, \r\n.... etc... nothing seems to help... my concat is always a concat. </p>
<p> </p>
<p>Any ideas? </p>
0
Comments
-
<p>Hi,</p>
<p> </p>
<p>You should be able to create a computed column like this one:</p>
<pre class="_prettyXprint _lang-">
row["CUSTOMERNAME"] + "\n" + row["CITY"] + "\n" + row["COUNTRY"]
</pre>
<p>and use it in a data item to display data on multiple rows:</p>
<p> </p>
<p>Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management