Option Description Default
-d Field delimiter Comma ','
-h The file has header row 1 = Yes
-p Starting record to display 1 = Default
-n Number of records to display 1 = Default, 0 = All
-q Quoted fieds " = Default
-c Number of columns in display 2 = Default, 3 = Max
-? Display the help message
==> csvb -h1 -n 3 -p 100 SAM_Exclusions_Public_Extract_14014t.csv
-e #------------------------------------------------------
#
# /usr/local/bin/csvb Arguments:
#
# -d , <= delimiter (',' =default)
# -q " <= quote's ("=default)
# -c 2 <= #output cols to display (2=default,max=3)
# -p 100 <= starting record (1=default)
# -n 3 <= #recs to display of 121872 (0=all,1=default)
# -h 1 <= file has header row (1=Yes)
#
# Source file: SAM_Exclusions_Public_Extract_14014t.csv
#
#------------------------------------------------------
#
#*** File: SAM_Exclusions_Public_Extract_14014t.csv[,] - Starting rec# 100, display 3 recs.
#*** Header (26 columns): Classification,Name,Prefix,First,Middle,Last,Suffix,Address 1,Address 2,Address 3,Address 4,City,State / Province,Country,Zip Code,DUNS,Exclusion Program,Excluding Agency,CT Code,Exclusion Type,Additional Comments,Active Date,Termination Date,Record Status,Cross-Reference,SAM Number
*** Rec#100 - 1/3 (NF38): SAM_Exclusions_Public_Extract_14014t.csv
Classification 01: Individual Country 14: USA
Name 02: Zip Code 15: 33179
Prefix 03: DUNS 16:
First 04: A. Exclusion Program 17: Reciprocal
Middle 05: JUMBO Excluding Agency 18: EPA
Last 06: MCDONALD CT Code 19:
Suffix 07: Exclusion Type 20: Ineligible (Proceedings *
Address 1 08: Additional Comments 21:
Address 2 09: Active Date 22: 8/12/2009
Address 3 10: Termination Date 23: 8/11/2014
Address 4 11: Record Status 24:
City 12: MIAMI Cross-Reference 25: "(also MCDONALD JUMBO, M*
State / Province 13: FL SAM Number 26: S4MR3QH7L
*** Rec#101 - 2/3 (NF26): SAM_Exclusions_Public_Extract_14014t.csv
Classification 01: Individual Country 14: GBR
Name 02: Zip Code 15: EC2V 8EY
Prefix 03: DUNS 16:
First 04: A. Exclusion Program 17: Reciprocal
Middle 05: LOPEZ Excluding Agency 18: TREAS-OFAC
Last 06: MIGUEL CT Code 19: 03-SDN-01
Suffix 07: Exclusion Type 20: Prohibition/Restriction
Address 1 08: Additional Comments 21: PII data has been masked*
Address 2 09: Active Date 22:
Address 3 10: Termination Date 23: Indefinite
Address 4 11: Record Status 24:
City 12: LONDON Cross-Reference 25:
State / Province 13: SAM Number 26: S4MR3QS26
*** Rec#102 - 3/3 (NF27): SAM_Exclusions_Public_Extract_14014t.csv
Classification 01: Individual Country 14: USA
Name 02: Zip Code 15: 105460413
Prefix 03: DUNS 16:
First 04: A. Exclusion Program 17: Reciprocal
Middle 05: STEPHEN Excluding Agency 18: HHS
Last 06: PACK CT Code 19: Z1
Suffix 07: Exclusion Type 20: Prohibition/Restriction
Address 1 08: Additional Comments 21: "Excluded by the Departm*
Address 2 09: Active Date 22: 9/20/2000
Address 3 10: Termination Date 23: Indefinite
Address 4 11: Record Status 24:
City 12: MILLWOOD Cross-Reference 25:
State / Province 13: NY SAM Number 26: S4MR3QVGD
Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.
Comments (0)