I'm working on removing an important spreadsheet from Google Docs, and maintain that in LibreOffice.
Thing: In G Docs I wrote a few macros to sort the file in various ways, using 4 and 5 fields.
Libre Calc only allows 3 sort fields, and the G-Doc macros don't work in Libre Calc.
I've written a #Python program to convert a CSV to a file with fixed length, and writing a #COBOL program to do the sorting for me.
Sorting multiple columns in Python is a PITA. In COBOL it's laughably simple.
I wish something like the IBM S/34 #GSORT would exist for Linux. That would make this even simpler.
@tshirtman I load the CSV simply using readlines(). I found that sorted-option, but the loaded CSV misses those 'key' thingies. (I'm still puzzled about that, I'm an old-fashioned programmer, as COBOL may indicate ;-)
Add comment