sorry, that should have been:
sort lines of fld "dataField" by item 4 of each
sort lines of fld "dataField" by item 3 of each
sort lines of fld "dataField" by item 2 of each
On 2 Sep 2005, at 00:25, Mark Smith wrote:
From the docs:
--
The sort command is a stable sort. This means that if the sortKey for
two cards is the same, sorting does not change their order, so you can
do two successive sorts to create subcategories within the major sort
categories. For example, to sort the cards of a stack by ZIP code and
sort within each ZIP code by last names, use these two statements:
sort cards by field "Last Name"
sort cards numeric by field "ZIP code"
--
so
sort lines of fld "dataField" by item 2 of each
sort lines of fld "dataField" by item 3 of each
sort lines of fld "dataField" by item 4 of each
Is this what you need?
Cheers,
Mark
On 2 Sep 2005, at 00:10, Stewart Lynch wrote:
I have data that needs to be sorted a certain way after I bring it in
to a
text field called DataField
Each line in the data has 6 items separated by a tab so I can set the
itemdelimeter to Tab
I need to sort the data by Item 2 then Item 3 then Item 4.
So, for example
3838033 R. Chin 1 B XESL 11 12
3838033 R. Chin 2 C XESL 10 17
3838033 J. Clemente 1 B SCH 11 23
3838033 R. Chin 1 D XESL 11 15
3838033 R. Chin 2 B XESL 11 15
3838033 R. Chin 1 C XESL 10 11
3838033 J. Clemente 1 A SS 9 27
3838033 R. Chin 1 D XESL 10 16
3838033 J. Clemente 1 A SCH 11 27
3838033 J. Clemente 1 D SCH 9 26
3838033 J. Clemente 2 A SS 11 26
3838033 J. Clemente 1 B SCH 9 28
3838033 J. Clemente 1 C SCH 10 29
Gets sorted as
3838033 J. Clemente 1 A SS 9 27
3838033 J. Clemente 1 A SCH 11 27
3838033 J. Clemente 1 B SCH 11 23
3838033 J. Clemente 1 B SCH 9 28
3838033 J. Clemente 1 C SCH 10 29
3838033 J. Clemente 1 D SCH 9 26
3838033 J. Clemente 2 A SS 11 26
3838033 R. Chin 1 B XESL 11 12
3838033 R. Chin 1 C XESL 10 11
3838033 R. Chin 1 D XESL 11 15
3838033 R. Chin 1 D XESL 10 16
3838033 R. Chin 2 B XESL 11 15
3838033 R. Chin 2 C XESL 10 17
I see that there is the command
Sort lines of field DataField by item 2
What would I do to have the lines sorted by item 2,3 and 4 in that
order?
*******************************************
........
: o/ : Stewart Lynch
: <| : Director of Instruction, Technology and Information Services
: / > : Richmond School District
:......: Richmond, BC Canada
Internet: [EMAIL PROTECTED]
https://public.sd38.bc.ca/~slynch
tel. (604) 668-6128 fax: (604) 668-6006
*******************************************
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
