Parsing multi-valued fields in Crystal Reports
Posted on 2008-10-14
I am pulling a multi-valued text string into Crystal Reports from a sql database. The field is a comment field in which multiple values are entered into sql. They are then stored in sql as a single text field, separated by: ý.
ie - teowtýCE.PHARM.TECH
I would like to take the text in this single Crystal Reports field and parse it out into two or more columns.
Column 1 = teowt
Column 2 = PHARM.TECH
Is there a way to do this in Crystal, or do I need to accomplish this via a SP on the SQL side? I am not a promgrammer by any means, so dumb it down for me please !
Any help would be greatly appreciated.