How to seperate the data in fields after commas

[lavadan]

Hi All,

I have a question on how to solve this in crystal XI:

I have a field from a table which looks like-
Sammy, Green, Public, Beach
I want to display it in crystal reports as
Sammy(Green, Public, Beach)
- i.e. after the first & last commas , there should be brackets

Does anybody have any idea how to implement this?

 

[dunlop1975]

local stringvar test := {database field}
local stringvar output;

output := left(test,instr(test,",")-1) & "(" & right(test,length(test)- instr(test,",") - 1) & ")";

This can be done without any variables by placing your database name anywhere it says test.

 

[lavadan]

Thanks a lot. It worked like a charm.