Hi Roger My first thought would be to set up an array having your numbers as keys. Cycle through each key counting the occurrence of each number in your master list and then separate out the key values that are greater than one. Use the offset function to reference each value in the master list - the subsequent values could be accessed by using the 'skip' parameter in the offset function.
Something like this (untested) --create an array and count repeat for each line myNumber in myNumberList add 1 to myNumberListArray[myNumber] end repeat put the keys of myNumberListArray into myKeys sort myKeys ascending repeat for each line myNumber in myKeys -- identify multiple values if myNumberListArray[myNumber] > 1 then put empty into linesToSkip repeat with tCount = 1 to myNumberListArray[myNumber] put lineoffset(myNumber, myNumberList, linesToSkip) into tValuePosition put "-"&tCount after line tValuePositionof myNumberList put tValuePosition into linesToSkip end if end repeat HTH On 29 September 2011 03:52, Roger Eller <roger.e.el...@sealedair.com> wrote: > There are several ways I could approach this, but I'm unsure which way is > best? I have a list of numbers that 'may' contain duplicates. I need to > sequence ONLY the duplicates without changing the order the list. If there > is only one, it does not need to be sequenced. > > Should I just repeat, and keep the content of line x in a variable, then > add > 1 to a sequence variable if the number is encountered again? Is there a > better way? Simple stuff, I know, but these lists can be really long, and > I > want it to process as quickly possible. > > 12345 > 12345 > 12344 > 12333 > 10112 > 12333 > > must become: > > 12345-1 > 12345-2 > 12344 > 12333-1 > 10112 > 12333-2 > > ˜Roger > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > -- Regards Ian McKnight iangmckni...@gmail.com ======================= _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
