fw2csv

Convert data file from fixed width format table to CSV

Add a Review
1 Download (This Week)
Last Update:
Download fw2csv-1.0.1.tar.gz
Browse All Files
BSD Linux

Description

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=4,10,11,20,30,36 -d '|' -header 1 | psql wsdb -c "copy mytable from stdin with csv delimiter '|'"

For the list of available options call
$ fw2csv --help

fw2csv Web Site

Update Notifications





Write a Review

User Reviews

Be the first to post a review of fw2csv!

Additional Project Details

User Interface

Command-line, Console/Terminal

Programming Language

C

Registered

2012-08-24
Screenshots can attract more users to your project.
Features can attract more users to your project.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.