Separating Arrays

[CNR123]

I've fields with some arrays.&nbsp;&nbsp;The items are separated with semicolons in database.&nbsp;&nbsp;I'm looking for a formula or something that put each item (past the semicolon) on a new line in Crystal Report.&nbsp;&nbsp;Any suggestions on how I can make this happen?<br><br>Thanks,<br>Craig

 

[MalcolmW]

In a formula put<br>Replace ({yourfield}, ';', Chr(10)) <br>this will search and replace the semicolon with a carriage return.&nbsp;&nbsp;Make sure the formula is formatted to print on multiple lines, or you will only see the first line.<br> <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>