Thanks very much, Dick and Peter! I'll try these out.
On Sep 26, 2014, at 8:55 AM, "Peter M. Brigham" <pmb...@gmail.com> wrote: > On Sep 26, 2014, at 12:24 AM, Peter Bogdanoff wrote: > >> My first foray into arrays: >> >> I want to sort a 2D array by one of the keys. >> >> The data consists of several 2-line groups that are in a field. The lines >> contain styled and linked characters that I want to retain after sorting: >> >> peaches >> pears >> >> apples >> oranges >> >> plums >> grapes >> >> I want to sort the data by line 1 of each 2-line group, then display the >> sorted data as styled text. >> >> I build an array: >> >> repeat with x = 1 to (the number of lines of field “tField" / 3) >> put line 1 of field “tField" into tMultiArray[x][1] >> put the htmlText of line 1 of field “tField" into tMultiArray[x][2] >> put the htmlText of line 2 of field “tField" into tMultiArray[x][3] >> delete line 1 to 3 of field “tField" >> end repeat >> >> How do I sort this array by line 1 of the plain text of each group? >> >> Then, how do I extract the data from the array—I need the 2nd & 3rd values >> only (the htmlText) to display again in the field (set the htmlText of line >> x of field “tField” to…?)? >> >> Is this the best method to sort this kind of data? The data comes as search >> results using Scott McDonald’s RunRev Planet Search tool, so I have to work >> with what the tool gives me. > > You could do it without any arrays: > > on sortIt tFldRef > put the htmlText of tFldRef into tData > put numtochar(4) into groupDiv > put numtochar(5) into itemDiv > replace "<p><p>" with groupDiv in tData > replace"<p>" with itemDiv in tData > replace groupDiv with cr in tData > set the itemdel to itemDiv > sort lines of tData by item 1 of each > replace cr with "<p><p>" in tData > replace itemDiv with "<p>" in tData > set the htmltext of tFldRef to tData > end sortIt > > Not tested, may need to do more parsing of HTMLtext before sorting…. But you > get the idea. > > -- Peter > > Peter M. Brigham > pmb...@gmail.com > http://home.comcast.net/~pmbrig > > > _______________________________________________ > 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 _______________________________________________ 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