| This data conversion allows you to
process a tab delimited data file, and reorder its contents using a
simple syntax as an output pattern. Use '$col[0]' to '$col[numberofcolumns-1]'
to refer to columns in the input file; use \t for tab. To refer to substrings, use $col[0][2..3] to
refer to characters 3 and 4 of the first field. If you want to refer
to the entire line, just use an Input Delimiter that is not found in
your input file, and you
can then refer to the line with $col[0], from which you can select
substrings to process a fixed record layout. Example: say that you want to reorder 5 input
fields in reverse order, and add an additional field at the beginning
and in front of the second field. The fields
will
be tab separated again: Someliteral\t$col[4]\t$col[3]\t$col[2]\tOtherliteral$col[1]\t$col[0]
Example 2: print field 3, a space, field 2, a space, and then field 1: $col[2] $col[1] $col[0]
Example 3: interpret the line as a fixed record format, extracting
just two substrings from the line, separated in the output with a tab:
$col[0][3..7]\t$col[0][0..1] |
