May 2007
1 post
3 tags
Convert fixed length column to Excel
I had to convert the output from sqlplus to an excel sheet. The problem was, that I had no influence on the creation, so I could spool the file directly to excel.
All I got were spool files like that:
CLASS_ID SUPER_CLASS_ID COUNT(*)
============== ============== ==========
128 8765 18
128 8765 131
128 8765 7
...