View Single Post
  #1   (View Single Post)  
Old 19th March 2009
gosha gosha is offline
Spam Deminer
 
Join Date: Jun 2008
Location: China
Posts: 256
Default table formatting (could not find better title)

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?
Reply With Quote