I have a table with the following sample values:
Code:
column1 column2 column3 column4
1 2 a b
1 2 c d
1 2 e f
is there a way to get this:
Code:
column1 column2 column3 column4
1 2 a b
c d
e f
I have more columns, but it is only to explain.
In fact this table is an output of postgresql, but I understand that this formatting is not possible in sql (right?). Of course, I could connect with MsAccess and use its report wizard, but I'd like to learn to do without Windows alltogether. If I had a i386 machine, I could try using OpenOffice. I checked google and found tools like Gedafe and Papyrus, but cannot get Gedafe to work (I know, I have to study) and Papyrus seems to be 100% Linux-centric.
So, my question is: can I do it with a tool like sed? Or how could I do it? Working with the computer, I very often get into this kind of formatting problems. What would the best language to learn to solve problems in autonomy?