Tabular data handling toolkit  


Manual page for Tabular(data)

TDH Utilities

The TDH utilities are a set of programs and filters useful in working with ordinary tabular ascii data from the command line or in shell scripts. They were developed to supplement standard unix utilities such as sort and uniq. Two of the utilities are designed to work specifically with tab-delimited exports from Excel/spreadsheets. A full-featured date and time package (libchron) is also included.


Download tdhkit10.tar.gz (130 kB, includes TDHkit and libchron)


What is tabular ascii data?

Tabular ascii data is any data set that is stored as ascii text, with one "record" per line, and fields separated by TABs or white space. The first line may be a field name header. The TDH utilities generally recognize lines beginning with // as comments; these lines are ignored during processing.


The TDH utilities


NameDescription
dateconvert(1) Convert dates to various notations.
fldfmt(1) Filter to print fields with formatting, or add a new field, or modify an existing field.
fldmap(1) Map fields by name from one file to another.
fldsel(1) Filter to select or omit fields. Fields can be specified by position, by name, or by range notation.
pjoin(1) Perform a relational join on two files. Standard, left, right, and lossless joins supported.
recsel(1) Filter to select records using a simple conditional expression given on the command line.
tabo(1) Display a file so that fields line up, regardless of length.
tdhfunction(1) Access TDH functions from shell scripts. There are functions for manipulating dates, times, numbers, strings, comma-delimited lists, and so on.
xlcells(1) Extract certain cells/fields from excel/spreadsheet export data using spreadsheet notation eg B2 or C24.
xlcleaner(1) Clean up excel/spreadsheet export data (round numeric values reasonably; remove trailing phantom fields, etc.)
libchron(3) a C API for manipulating dates and times using many notations. Perform date arithmetic, convert dates from one format to another, etc. To build, cd libsrc; make libchron.



Environment

TDHKIT_CONFIG

(Optional) The full path name of your TDH config file for customizing the way the TDH utilities operate.


Author

Steve Grubb

Source code and documentation are freely downloadble from http://midriff.sourceforge.net/tdhkit

Other freeware packages by Steve


Tabular data handling toolkit 
Copyright Steve Grubb


Markup created by unroff 1.0,    September 24, 2003.