Fields...

[CNR123]

<b> I have a database field that have an array of elements in it.&nbsp;&nbsp;In Crystal, I would like to separate those elements into separate fields.&nbsp;&nbsp;Any suggestions on how this might be achieved?

 

[Guest_imported]

use the instrg() function

 

[LindaC]

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;You can split apart a string field by using the formulas:<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Left (str, length)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Right (str, length)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Mid (str, start, length) <br>Create a different formula for each field.<br> <p>LindaC<br><a href=mailto:lcastner@co.orange.ny.us>lcastner@co.orange.ny.us</a><br><a href= > </a><br>