Sorting Lines by Item

[Mark Smith]

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: slynch at richmond.sd38.bc.ca
>> https://public.sd38.bc.ca/~slynch
>> tel. (604) 668-6128 fax: (604) 668-6006
>> *******************************************
>>
>>
>>
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your 
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>