Open Source Perl CSV Software

A set of Unix command line tools for quick and convenient batch processing of tabular text files (a.k.a., tab-delimited, csv, or flat file format) with a header line. Provides delimiter and compression detection, column reference by name. * tblmap: per-line ("map") computation: derive columns through an expression, delete, reorder, filter rows. * tblred: compute ("reduce") aggregations (e.g., sum, average) over groups defined by key columns. * tbldesc: Summarize columns in file (e.g., proportion of character/numeric values, min/mean/median/max, missing values, correlation with a target column). * tbljoin: Relational join without the need of pre-sorting and column matching. * ... See HostedApps/MediaWiki for examples.

Elevations moves data from Excel to Unix systems. It connects VBA with Cygwin SSH, CGI and HTTP POST to deliver to a QuantLib C++ server through pipes. Provides C++ classes to process CSV files and the strings to C++ types. File schema definitions.

This script takes the Western Australian linked health data provided by the Data Linkage Unit and converts it to a TAB delimited format that is easier to import into SPSS or Excel etc. Mileage may vary.

dhcp-gen is a perl script that was written by me and Trond Erik Dalho to simplify editing dhcpd.conf for adding static ip to computers and equipment on our school. It also made it easier to do manage the network by limiting some computers access to the local network only. Creating closed networks. And it also worked as a database over all our computers and equipment, making it easier to keep track of everything. All information about equipment is stored inside csv files which are comma separated.