PureBytes Links
Trading Reference Links
|
Um,
You're right, the column is string. I'll try and switch it to numeric.
Thanks!
Stewart
----- Original Message -----
From: <uenal.mutlu@xxxxxxxxxxx>
To: <amibroker@xxxxxxxxxxxxxxx>
Sent: Tuesday, May 13, 2003 10:55 PM
Subject: Re: [amibroker] Sorting a Table using ABtool
> Hi Stewart,
> what type has that column? Is it numeric or string?
> If numeric, then it should work as in maths (and how
> you described it should be), otherwise if string, then
> you should create one additional numeric column and
> write there the value there after converting it to a number
> by calling xxToNumber(str);
>
> > Do I need to split the table into two with positive numbers in one table
and
> > negative in another?
>
> As stated, normally you can do all just in the same table.
> For sorting a string column which consists of digits,
> you should convert these "string numbers" to ordinary
> numbers before putting them into the table, or simply
> add another column, now a numeric type, and store it
> there, and sort on that column.
>
> I hope I understood the problem right; please let me
> know if it still doesn't work the way you want it.
>
> UM
>
>
> ----- Original Message -----
> From: "Stewart" <stewart@xxxxxxxxxxxxxxxx>
> To: <amibroker@xxxxxxxxxxxxxxx>
> Sent: Tuesday, May 13, 2003 11:40 PM
> Subject: [amibroker] Sorting a Table using ABtool
>
>
> > Hi UM,
> >
> > If I'm sorting a column of a table with negative and positive numbers,
and I
> > want the least negative to be on the bottom and the highest positive to
be
> > on top like this:
> >
> > 9
> > 8
> > 3
> > 2
> > -1
> > -4
> > -8
> >
> > Do I need to split the table into two with positive numbers in one table
and
> > negative in another?
> >
> > Thanks,
> >
> > Stewart
>
>
>
>
> Send BUG REPORTS to bugs@xxxxxxxxxxxxx
> Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
> -----------------------------------------
> Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
> (Web page: http://groups.yahoo.com/group/amiquote/messages/)
> --------------------------------------------
> Check group FAQ at:
http://groups.yahoo.com/group/amibroker/files/groupfaq.html
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Rent DVDs from home.
Over 14,500 titles. Free Shipping
& No Late Fees. Try Netflix for FREE!
http://us.click.yahoo.com/BVVfoB/hP.FAA/uetFAA/GHeqlB/TM
---------------------------------------------------------------------~->
Send BUG REPORTS to bugs@xxxxxxxxxxxxx
Send SUGGESTIONS to suggest@xxxxxxxxxxxxx
-----------------------------------------
Post AmiQuote-related messages ONLY to: amiquote@xxxxxxxxxxxxxxx
(Web page: http://groups.yahoo.com/group/amiquote/messages/)
--------------------------------------------
Check group FAQ at: http://groups.yahoo.com/group/amibroker/files/groupfaq.html
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|