Depends on whether the data is known to be already in order. If not,
then you need to uncomment the sort command.
btw. sorry, this doesn't use arrays, but it will be much faster than the
array method(s) if the data set is large.
function other pMin, pMax, pList
put empty into tMissingList
put empty into tDuplicateList
-- sort the data if needed
-- sort items of pList ascending numeric
put pMin-1 into tLast
repeat for each item N in pList
if N = tLast+1 then
put N into tLast
next repeat
end if
if N = tLast then
put N & comma after tDuplicateList
next repeat
end if
repeat with i = tLast+1 to N-1
put i & comma after tMissingList
end repeat
put N into tLast
end repeat
return (char 1 to -2 of tMIssingList) &cr& \
(char 1 to -2 of tDuplicateList)
end other
-- Alex.
On 16/12/2010 23:29, william humphrey wrote:
My math skills are terrible but this is something I can do in excel but
which should also be easy to do with a nested array in livecode. I want to
build a function that returns the numbers that are out of sequence in a list
of numbers. Say you are given (3,4,5,6,6,7,8,9,10,12,13,13,14) and the
function should return:
(1,2,11 - missing)
(6,13 - duplicate)
Can someone please help me write this function?
Thanks in advance.
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
