<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>
