print_record

NAME

SYNOPSIS

print_record [ "field_separator" ]

AVAILABILITY

DESCRIPTION

The first row is treated as header row.

White spaces adjacent to the field separators are trimmed, empty lines and # - commented lines are ignored.

To select named columns from the CSV data prior to the formatting of the list with print_record use select_columns(3).

OPTIONS

-h

usage message.

"field_separator"

field separator. If not specified, the default field separator is the semicolon (;).

If the first line is sep=S as seen as result of some spreadsheet exported CSV files, the field separator S is used.

ENVIRONMENT

EXIT STATUS

0

no error.

4

usage displayed.

5

version displayed.

FILES

EXAMPLES

1) print CSV data as record

The following CSV data received via pipe

  type cities.csv

  ZIP;CITY;STATE;CNT;COUNTRY
  93117;Goleta;CA;USA;United States of America
  8222;Beringen;SH;CH;Switzerland
  8005;Cape Town;WC;RSA;South Africa

  type cities.csv | print_record

results in the output:

      ZIP  93117
     CITY  Goleta
    STATE  CA
      CNT  USA
  COUNTRY  United States of America
 
      ZIP  8222
     CITY  Beringen
    STATE  SH
      CNT  CH
  COUNTRY  Switzerland
 
      ZIP  8005
     CITY  Cape Town
    STATE  WC
      CNT  RSA
  COUNTRY  South Africa
 
  (3)

2) print selected columns of CSV data as records

The columns CNT, ZIP and CITY of the CSV data are selected using the select_columns(3) command and then formatted to a list using the print_list command

  type cities.csv

  ZIP;CITY;STATE;CNT;COUNTRY
  93117;Goleta;CA;USA;United States of America
  8222;Beringen;SH;CH;Switzerland
  8005;Cape Town;WC;RSA;South Africa

  type cities.csv | select_columns ";" "CNT;ZIP;CITY" | print_record


what will result in the output:


   CNT  USA
   ZIP  93117
  CITY  Goleta
 
   CNT  CH
   ZIP  8222
  CITY  Beringen
 
   CNT  RSA
   ZIP  8005
  CITY  Cape Town
 
  (3)

SEE ALSO

NOTES

BUGS

AUTHOR

COPYRIGHT

This is free software; see WA2LWinTools/man/COPYING for copying conditions. There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.