|
Something like this might work??
Starting with sample data
field - Value
10,20,30,40,50,60,70,80,90,100
40,20,30,40,50,60,70,80,90,100
50,20,30,40,50,60,70,80,90,100
the following formula was able to return the values in the format
10
20
30
40
50
60
70
80
90
100
********************************
stringvar output;
output :="";
numbervar i;
For i := 1 to count(split({Sheet1_.Value},",",1)) do
(
if split({Sheet1_.Value},",") <>" " then
output := output + (split({Sheet1_.Value},","))[1] +chr(13);
if split({Sheet1_.Value},",") <>" " then
output := output + (split({Sheet1_.Value},","))[2] +chr(13);
if split({Sheet1_.Value},",") <>" " then
output := output + (split({Sheet1_.Value},","))[3] +chr(13);
if split({Sheet1_.Value},",") <>" " then
output := output + (split({Sheet1_.Value},","))[4] +chr(13);
if split({Sheet1_.Value},",") <>" " then
output := output + (split({Sheet1_.Value},","))[5] +chr(13);
if split({Sheet1_.Value},",") <>" " then
output := output + (split({Sheet1_.Value},","))[6] +chr(13);
if split({Sheet1_.Value},",") <>" " then
output := output + (split({Sheet1_.Value},","))[7] +chr(13);
if split({Sheet1_.Value},",") <>" " then
output := output + (split({Sheet1_.Value},","))[8] +chr(13);
if split({Sheet1_.Value},",") <>" " then
output := output + (split({Sheet1_.Value},","))[9] +chr(13);
if split({Sheet1_.Value},",") <>" " then
output := output + (split({Sheet1_.Value},","))[10] +chr(13);
);
output
********************************
this formula will only work if there are a consistent number of items in the array
Hope this helps
|
IP Logged
