fw2csv
Convert data file from fixed width format table to CSV
Fixed width data files are probably the most annoying data to import into database.
This utility allows user to insert user-defined column separators into user-defided positions of flat file table given in fixed-width format.
I am using this utility to import astronomical catalogs provided as flat tables at CDS ftp-server into postgresql;
Build:
$ make all [cc={icc|gcc}]
Install:
$ make install [prefix=/path/to/your/bin/directory]
Example of usage:
$ gzip -dc table.dat.gz | fw2csv --stops...