valid

Validates the structure of one or more rdbtables. Checks number of data fields per line, max width of column names and data values, and checks numeric data type values. Reports errors by line number and column name.

Reads from STDIN if filenames are not given. Writes diagnostic information on STDOUT. Options may be abbreviated.

Options:

• -help - Print this help information.
• -l[x] - List exact data values with visible delimiters, using 'x' as the delimiter. The value of 'x' may be multi-character, default is "|".
• -nw - No check of the width of the data.
• -size - Report max size of actual data in each column.
• -templ - Generate a template file from the header of the table, on STDOUT. Does NOT check the body of the table.

If there is more than one file given each file will be identified on the output.

The '-size' option has proven very useful as it shows the actual size of the largest data value for each column, in addition to the template information. The command:

        valid  -size  sample

            0                 NAME  6     6
            1                COUNT  5N    2
            2                  TYP  4     1
            3                  AMT  5N    4
            4                OTHER  8     7
            5                RIGHT  8>    5
        Columns: 6, Rows: 6, File format valid  sample