Hi all master,
I can not get the result that i wish for, any opinion to advice...Thanks
The @Test formula consist of : "abc,def,ghi,".
i want the result to be in the like below:
abc
def
ghi
------- My code ------
Local StringVar AllHour;
Local NumberVar i:=1;
Local StringVar j;
Local NumberVar k:=0;
AllHour :=
{@Test};
k := length(AllHour);
while i <= k and AllHour <> "" do
(j := ToText(Mid(AllHour, i,InStr(i,AllHour,",")-1)) + chr(10);
i := i + 4;
);
j;
Thanks a lot
Eric