VALID

valid - validate the structure of one or more rdbtables

SYNOPSIS

valid [options] [file ...]

OPTIONS

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.

DESCRIPTION

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.

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

shows the following output:

      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

The last two columns above show the defined size of each column in the rdbtable, and the actual maximum size of the data values for each column in the rdbtable.

AUTHOR

Walter Hobbs

Additional code by Diab Jerius (djerius@cfa.harvard.edu)