Converting multiple codes to descriptions (Crystal XI) 1

[ClareR]

Hi all

I need help with a (probably simple) formula that will convert a field code to display a description.

The field holds codes like ,1, ; ,2, ; ,3, etc up to ,230,

I need to translate the code to show a description, which is easy if the field equals a specific code. The problem I am having is the field might have more than one code contained within it and I need to display ALL the descriptions.

I really hope someone can help

Many thanks

Clare

 

[ClareR]

Hi LB

I was being a complete and utter noddy!

I have worked out what I need to do now and it works perfectly.

Thank you so much for your help!

Clare