fw2csv Icon

fw2csv

Convert data file from fixed width format table to CSV

Add a Review
0 Downloads (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

KEEP ME UPDATED

Other Useful Business Software

The Leading Provider of Business VoIP Phone Systems Icon

Award-Winning Business VoIP Phone System

The Leading Provider of Business VoIP Phone Systems Icon
1 of 5 2 of 5 3 of 5 4 of 5 5 of 5
62 Reviews
  • Unlimited Calling, Faxing, Video Conferencing
  • 24/7 U.S Based Customer Support
  • Super Reliable, Simple to Use
Write a Review

User Reviews

Be the first to post a review of fw2csv!

Additional Project Details

User Interface

Console/Terminal, Command-line

Programming Language

C

Registered

2012-08-24

Thanks for helping keep SourceForge clean.

Screenshot instructions:
Windows
Mac
Red Hat Linux   Ubuntu

Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)

More information about our ad policies
X

Briefly describe the problem (required):

Upload screenshot of ad (required):
Select a file, or drag & drop file here.

Please provide the ad click URL, if possible:

Get latest updates about Open Source Projects, Conferences and News.

No, Thank you