Odd sort of numbers after text import in DataGrid

[Terry Judd]

On 11/05/2011 09:07 AM, "tbodine" <lvhdgc7 at gmail.com> wrote:

> Hi,
> Having a bit of trouble sorting score numbers after importing a
> tab-delimited text file. Using dgText for import into a table, sorting the
> score column shows:
> 0
> 9
> 10
> 100
> 11
> 
> Is there a way to change certain columns to be sorted as number data instead
> of text? 

Tom - try this...
1. Select the datagrid
2. bring up the property inspector
3. go to the columns pane
4. select your column
5. check the sort by column checkbox
6. choose numeric from the dgColumnSortType popup
7. that's it

Terry...

> 
> Thx,
> Tom Bodine
> 
> 
> --
> View this message in context:
> http://runtime-revolution.278305.n4.nabble.com/Odd-sort-of-numbers-after-text-
> import-in-DataGrid-tp3513277p3513277.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
> 

--
Dr Terry Judd | Senior Lecturer in Medical Education
Medical Education Unit
Melbourne Medical School
The University of Melbourne