Fixed Width Text File Conversion Tool

This utility is used to convert a fixed width text file, such as the data files provided by BOEMRE, into a tab-delimited text file that can be easily imported into Excel or Access.

Documentation

Usage: convert-fixed-width.py [options] COLUMNS INPUT OUTPUT

    COLUMNS
     name of a file containing the widths and names of the columns in the input file.  Specify one column per line in the order that they appear in the input file.  The width of the column should be at teh beginning of the line, followed by a space and then the name, which cannot contian any spaces itself
     e.g.
     3 rowid
     5 area_code
     25 name
     100 description
    
    INPUT
    file name of the input file containing fixed width text data
   
    OUTPUT
    file name to use for the output


Reads a fixed-width text file and converts to tab-delimited

Options:
  -h, --help     show this help message and exit
  -q, --quiet    Only output error messages
  -v, --verbose  Output debugging information

How to Use

[TDB]
ċ
convert-fixed-width.py
(3k)
Paul Woods,
Sep 13, 2011, 5:53 AM
Comments