This example demonstrates use of the special "col" (or columnar) format. Each record is on one line. Each field resides in specific character columns.
database /tmp/testdb table log col datefmt yy-mm-dd HHMM trimspace keepfirst # Name Type Tag field Date date 1-13 field Future char 14 field Who varchar 15-22 field What varchar 24-
Here is sample data for the above schema. (some lines have been wrapped to fit on the page)
95-04-21 1300 mike john smith - acme rockets, called for price info 95-04-21 1301 bob jane doe - text 'r' us, called for joe, regarding ret'ing some voice mail software 95-04-21 1800*sally remember telephone maintenance tomorrow morning