Idea: Multi-column ALIGN

George
Administrator

Posts: 4,062

Idea: Multi-column ALIGN Jun 5, 2022 13:51:12 GMT -5

Quote

Post by George on Jun 5, 2022 13:51:12 GMT -5

Robert: What you really want, I think, is a CSV [COLMAX] command which requests each CSV 'column' to be the MAX size of all elements in that column. Something like this?

George

Name,LWDate,Size,Lines,LRDate                                                   
"D:\Documents\SPFLite2\_ObjIO.inc                          ","2022-05-09  14:50","17,230  ","295  ","2022-05-06"
"D:\Documents\SPFLite2\Backup.BAT                          ","2022-05-04  16:15","1,220   ","33   ","2022-05-05"
"E:\GDrive\Test Data\bas.auto                              ","2019-03-29  13:51","58,223  ","2,403","2022-05-08"
"D:\Documents\SPFLite2\Distribution\Changes.txt            ","2022-06-04  15:52","51,406  ","1,121","2022-06-04"
"D:\Documents\SPFLite2\Resource File\HnD.pas               ","2022-05-18  11:26","37,561  ","474  ","2022-05-18"
"D:\Documents\SPFLite2\Resource File\HnDIndex.txt          ","2022-05-18  11:28","209,288 ","     ","2022-05-18"
"D:\Documents\My Apps\InfoBar\InfoBar.txt                  ","2022-05-21  12:34","1,566   ","35   ","2022-05-21"
"C:\Users\George\Desktop\Parse Table.txt                   ","2022-05-20  11:35","5,761   ","83   ","2022-05-22"
"D:\Documents\My Apps\Reminders\Reminders.txt              ","2022-05-08  11:47","416     ","8    ","2022-05-08"
"E:\GDrive\Install Stuff\Advanced PDF Compressor\Serial.txt","2013-02-20  13:39","3,254   ","62   ","2022-05-18"
"D:\Documents\SPFLite2\SPFLite.pbprj                       ","2022-05-11  09:56","1,983   ","     ","2022-05-04"
"E:\GDrive\Test Data\SwapRobert.txt                        ","2022-06-04  14:25","696     ","8    ","2022-06-04" 
"D:\Downloads\szprocs\szprocs.bas                          ","2018-04-10  00:07","29,238  ","1,112","2022-06-04"
"e:\GDrive\Test Data\testdata.txt                          ","2022-05-15  12:12","17,010  ","208  ","2022-06-03"
"D:\Documents\SPFLite\MACROS\try4.macro                    ","2022-05-06  09:49","113     ","     ","2022-05-06"
"E:\GDrive\Misc Data\UnZipit.bat                           ","2022-05-16  10:00","127     ","5    ","2022-05-16"    
"D:\Documents\SPFLite2\UPXCFG.BAT                          ","2022-05-05  12:56","148     ","5    ","2022-05-05"   
"D:\Documents\SPFLite2\UPXSPF.BAT                          ","2022-05-05  12:55","1,150   ","32   ","2022-05-05"

George
Administrator

Posts: 4,062

Idea: Multi-column ALIGN Jun 6, 2022 9:38:31 GMT -5

Quote

Post by George on Jun 6, 2022 9:38:31 GMT -5

Robert: I tried CSV files with blanks as you showed. LibreOffice loads them into a spreadsheet correctly without complaint, I assume Excel is at least as smart.

I also found the bug in ALIGN that caused the ALIGN command to mishandle the MAX operand.

BUT, even with that fix, AND ALIGN returning the found column number, we have a problem. ALIGN is quoted string blind, so, with a comma as delimiter (for CSV), data values like "12,345" muck it all up. I think the COLMAX option is the only way to go.

George

George Administrator Posts: 4,062	Idea: Multi-column ALIGN Jun 6, 2022 12:31:14 GMT -5 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by George on Jun 6, 2022 12:31:14 GMT -5 Hmmm, something's not right. I'll refresh it with a good version right away George

George
Administrator

Posts: 4,062

Idea: Multi-column ALIGN Jun 7, 2022 8:59:00 GMT -5

Quote

Post by George on Jun 7, 2022 8:59:00 GMT -5

The reason for quoting was just simplicity, the logic doesn't even know what field it's processing, so it just quotes everything.
The column definitions are all table driven from the FM layout string. I think I'll add the COLMAX or MAXCOL or .?. and do the comma allignment.

George

George Administrator Posts: 4,062	Idea: Multi-column ALIGN Jun 7, 2022 11:49:45 GMT -5 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by George on Jun 7, 2022 11:49:45 GMT -5 OK, I'll change to ALIGN. I've managed to clean up the numeric fields - commas and quotes removed, right aligned if ALIGN is requested. George

George Administrator Posts: 4,062	Idea: Multi-column ALIGN Jun 7, 2022 14:35:52 GMT -5 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by George on Jun 7, 2022 14:35:52 GMT -5 Robert: I'm aligning numbers right and everything else left. Alignment obviously only occurs with the ALIGN operand. New Beta coming up. George

mueh Senior Member Posts: 429	Idea: Multi-column ALIGN Jun 9, 2022 2:59:55 GMT -5 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by mueh on Jun 9, 2022 2:59:55 GMT -5 Hi George! Noticed that in FM Recent Files LRDate is shown by default . If you specify LRDATETIME in opt FM you will get redundant Data ( 2 LRDate fields ) one with time and one without . Thanks

George Administrator Posts: 4,062	Idea: Multi-column ALIGN Jun 17, 2022 11:24:10 GMT -5 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by George on Jun 17, 2022 11:24:10 GMT -5 MUEH: Checked out LRDATE. No idea of an original reason for it being there, but LRDATE was being automatically added for the Recent lists. Seems a dumb idea, so I removed it. George

Idea: Multi-column ALIGN

Post by George on Jun 5, 2022 13:51:12 GMT -5

Post by George on Jun 6, 2022 9:38:31 GMT -5

Post by George on Jun 6, 2022 12:31:14 GMT -5

Post by George on Jun 7, 2022 8:59:00 GMT -5

Post by George on Jun 7, 2022 11:49:45 GMT -5

Post by George on Jun 7, 2022 14:35:52 GMT -5

Post by mueh on Jun 9, 2022 2:59:55 GMT -5

Post by George on Jun 17, 2022 11:24:10 GMT -5