Take comma separated string and have it look like justified list

[BHScripter]

Hi:
I have a crystal 9 report that gets its data from a SQL Query. One of the fields returns a comma separate string of the amenities at a property such as 24 hour fitness center, courtesy patrol, Spa like swimming pool, etc. This list can have a variable # of items as each property is unique. I want these amenities to show on my report in a justified list (i.e. one after the other vertically) rather than having a comman separate line. It seems this should be easy but I'm really not sure how to do this.

Thanks for any help.

 

[BHScripter]

Nevermind, got it!

 

[lbass]

Please explain your solution so the thread becomes meaningful to others.

-LB

 

[BHScripter]

this was my solution (in basic syntax):

dim propamenities as string
if ISNULL({Command.communityamenity}) or {Command.communityamenity} = "" then
propamenities = "None"
else
propamenities = Replace ({Command.communityamenity}, ",", Chr(10))
propamenities = Replace (propamenities, ",", Chr(10))
end if
formula = propamenities