sorting table fields

[J. Landman Gay]

Viktoras Didziulis wrote:
> Hi and Seasons Greetings for all! 
>  
> are there any simple ways to do sort in table fields in Revolution like
> first sort by column A, then by column B, then by C... 

Table fields are just regular fields with tabs between the data. So you 
can set the itemdelimiter to tab, and then just sort the data normally:

  set the itemDelimiter to tab
  sort field 1 by item 2 of each
  sort field 1 by item 3 of each

The sort command is stable, and retains the previous sort order unless 
the next sort requires a change, so in the above example lines will 
remain sorted by item 1 unless item 2 forces a line into a new position. 
See the "sort" command in the docs for more info.

-- 
Jacqueline Landman Gay         |     jacque at hyperactivesw.com
HyperActive Software           |     http://www.hyperactivesw.com