LinkBack URL
About LinkBacks
Reply With Quote
Sorting.exe - Version 16.1, February 2011
As I said the other day, while working on the new Bright6, I was hit with some performance issues. No, it would have been almost mission-impossible to attempt this kind of Bright6 prior to 2008. My computer would have had a helluva time! Even now it seems to me Bright6 is somehow futuristic. It will benefit enormously from the computers of the future. Let’s not forget, as they also say, the future is always just around the corner!)
Long tests might have been a blessing in disguise (praise Almighty Number!) While some programs are running in background, I can work on other tasks. Like this super upgrade to Sorting.exe. I added two new functions:
~ Sort Files as Text Lines
~ Sort Columns of Numbers.
I know how anxious people are to get their hands on the new Bright6. Until then, you can use the Sort Columns of Numbers function to sort your W6, MD6, etc. winning reports.
Furthermore, you can sort any numeric file you want — as long as it contains formatted columns (like in our W6 reports). Even better news: You can sort on multiple columns, including ALL columns in the file. But that that’s not all: You can also sort in ascending order, or descending order! More? Yes, you don’t have to sort only from the left column to the right. For example, sort first on column #1 (the primary key), then on column #3, then on column #3. You can set, for example, column #7 as the primary key, then sort on column #4, then on column #9, then on column #2.
Be forewarned: The new sorting function requires special attention to detail! You must write down precisely where a column starts, and how wide it is (i.e. how many digits in the largest number). You should also count precisely the number of lines in the header, if the file has one (e.g. the header of W6 has 13 lines).
Be sure also not to count in the column width the ending +/- sign of any column in W, MD, GR, etc. reports.
The best method is to create, then print, a text file with all columns in the report files, or other numeric files in text format. I’ll give you a hand now. I’ll write the starts and widths of the columns in W6. It helps you feed the correct data to Sorting.exe:
You notice that the start of a column is 2-3 spaces to the left of the largest number in the field. It’s for safety: There might be some unexpectedly large numbers in the future.Code:Column "Sum" Start = "7" Width = "6" Column "Pot" Start = "16" Width = "3" Column "One" Start = "21" Width = "3" Column "Two" Start = "26" Width = "3" Column "Three" Start = "31" Width = "5" Column "Four" Start = "37" Width = "6" Column "Del4" Start = "45" Width = "6" Column "Del5" Start = "53" Width = "7" Column "Del6" Start = "62" Width = "9" Column "Bun6" Start = "73" Width = "4"
You need a text editor to load the reports (text or ASCII files). The editor must show the line and column numbers; e.g. MDIEditor And Lotto WE. Move the insert point in front of the largest number in the column you wanna sort. Move the point to the left 1-3 spaces, if available. From there, press the right-arrow key to the right and count how many characters until immediately after the last digit in the number. Do not count the +/- sign in the W reports.
This is not beta software. I tested Sorting.exe a few times. If there are errors, they are caused by bad filenames or, especially, bad values for start and width of column, and wrong header. But, then again, as we noticed quite a bit around here, there is no such thing as perfection. If you discover other types of errors, please let me know. I’d appreciate that.
Follow these download links:
Sorting.exe, Version 16.1, February 22, 2011.
CMsort.exe.
Best of luck from Parpaluck!
I started this writing around 9 PM. We are under a severe winter weather warning. Nevertheless, it is beautiful to watch outside. I see the snow falling in the outdoor lights. Oh, baby! O wonderful Inner Child of mine!
Ion Saliu
Originally Posted by Ion Saliu
Bookmarks