Hi all,
I'm a new member and a big fan. I've come to an issue for which I haven't found a solution in any of the threads. Here goes...
I'm using Crystal Reports 2008.
I have a field in which there are numerical codes seperated by spaces (text string format). Each code has a value.
CODE Value
```` ``````````
01 Apples
02 Bananas
03 Carrots
04 Rice
05 Mangos
However, not all code values are the same per individual record. Every record has it's own entry. Here's what I mean,
RECORD ENTRY
``````` ````````
101 01 02
102 01 03 05
103 04
104 01 02 03 04 05
I need to replace the codes each record with it's corresponding value. The result has to be in a comma format. The result per record on the report should look like the "DESIRED RESULTS" below:
RECORD DESIRED RESULT
``````` ``````````````
101 Apples, Bananas
102 Apples, Carrots, Mangos
103 Rice
104 Apples, Bananas, Carrots, Rice, Mangos
I've been able to: REPLACE({Table.field},"01","Apples"). The result was simply "Apples" in the report (as expected), but I don't know where to go from this point. How do I include the multiple values with commas?
Thanks in advance!
I'm a new member and a big fan. I've come to an issue for which I haven't found a solution in any of the threads. Here goes...
I'm using Crystal Reports 2008.
I have a field in which there are numerical codes seperated by spaces (text string format). Each code has a value.
CODE Value
```` ``````````
01 Apples
02 Bananas
03 Carrots
04 Rice
05 Mangos
However, not all code values are the same per individual record. Every record has it's own entry. Here's what I mean,
RECORD ENTRY
``````` ````````
101 01 02
102 01 03 05
103 04
104 01 02 03 04 05
I need to replace the codes each record with it's corresponding value. The result has to be in a comma format. The result per record on the report should look like the "DESIRED RESULTS" below:
RECORD DESIRED RESULT
``````` ``````````````
101 Apples, Bananas
102 Apples, Carrots, Mangos
103 Rice
104 Apples, Bananas, Carrots, Rice, Mangos
I've been able to: REPLACE({Table.field},"01","Apples"). The result was simply "Apples" in the report (as expected), but I don't know where to go from this point. How do I include the multiple values with commas?
Thanks in advance!