Help in crystal reports formula

[sudhaMurugesan]

Hi all,
I have a datafield withthis value
name =john, sudha, chella, honey, etc and I need to display like this
john
sudha
chella
honey
etc. by using formula field. How can i do this
I used split function and some array function. but its not working ? Any suggestions please
My code is

numbervar number0fcommas := 0;
//checking for commas
if (("," in {ExportView.PalletDimension})= true) then
(
Global StringVar Array dimension := split({ExportView.PalletDimension},",");
number0fcommas := ubound(dimension);//it shows array length correctly
Local NumberVar i ;
Local StringVar str := "";
//this for is not working
//for i := 1 to number0fcommas do
//(
//str = str + split({ExportView.PalletDimension},",")[i] + chr(010)// for line break
//)
//
)
else
{ExportView.PalletDimension};

thank you

[radcaesar]

Check ur usage of split method
Heres 4 ur ref,

http://msdn2.microsoft.com/en-us/library/system.string.split.aspx

[sudhaMurugesan]

Hi radcaesar ,
Thanks for your reply. I still find difficulties. is that possible to collect the array elements in a string variable using for loop like this

for i:= 1 to arraylength do
(
local stringvar str ="";
str := str + array[i] + chr(010);
)
str;
//chr(010) is used for line break

if this is possible in crystal reports formula , then i would get my answer;
please reply.