TDH Utilities

TDH utilities are a group of programs useful in working with tabular data, from the command line or in shell scripts. TDH utilities work nicely in concert with the standard unix utilities sort, uniq, etc.

TABULAR DATA

SUGGESTED USES

• perform template processing eg. merging tabular data files into formatted reports
• select certain records using a conditional expression
• select certain fields based on position, name, or range
• print fields using a certain format
• set up logical records so that fields are identifyable by name
• perform relational joins using two tabular data files.
• perform date format conversions
• display tabular data so that the columns line up
• use a wide variety of string, list, date, time, etc. functions in your shell scripts
• work with tab-delimited spreadsheet data or access individual cells .
  
  
  

THE UTILITIES

dateconvert

performs date format conversions, either on a stream of data or on a single case.

dbcat

does a 'cat' on a pocketSQL data file, optionally adding a field name header

fldfmt

prints selected fields from a stream of data, with formatting

fldsel

selects fields from a stream of data

hexec

is a wrapper to allow sort(1) and other utilities to work with data files that have a field name header

pjoin

performs a relational join between two files.

recdef

displays a logical record format in tabular form.

recprint

displays data records in fieldname:value form

recsel

selects records based on a conditional expression

scriptpal

performs template processing, merges tabular data into a formatted template, etc. Uses the same script syntax as cgipal.

tabo

displays tabular data so that columns align visually

xlcells

retrieves cells by spreadsheet address, eg 3A, from a tab-delimited file

xlcleaner

cleans up tabular data files; designed for removing glitches present in MS Excell export text files.

ENVIRONMENT

TDHKIT_CONFIG

Holds the name of a project config file . Not always required, but useful when using scriptpal(1) or if you want set default utility behavior.

Other environment variables

AUTHOR

Source code and documentation are freely downloadble from www.sgpr.net