[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [amibroker] Sorting a Table using ABtool



PureBytes Links

Trading Reference Links

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



------------------------ 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/