CSVfox
Leverage Your Data.
 English

±hide

Prevents one or more CSV columns from output

Description

This command ignores columns from reading (when input) or hides them from output (when writing).
The most simple case is hiding just one unwanted field.
But you can also enter a list of fields to hide. In this case, it will is a comma-separated list of CSV column names (or numbers), and can even include column ranges denoted with a hyphen.

Pattern

±hide[Fieldname] ±hide=[Fieldname] ±hide[AField],[AnotherField],... ±hide=[AField],[FirstOfMoreFields]-[LastOfMoreFields],...

Usage examples

This is the input file names.csv.
names.csv
CityFirstNameLastNameBirthDriver License
RomeAndreaBocelli1958y
Los AngelesLieutnantColumbo1927y
LondonHerculePoirot1910-
New YorkTheodorosKojak1922y
csvfox names.csv -hide[FirstName] lastnames.csv
This hides the column FirstName. The resulting CSV table is written to lastnames.csv.
lastnames.csv
CityLastNameBirthDriver License
RomeBocelli1958y
Los AngelesColumbo1927y
LondonPoirot1910-
New YorkKojak1922y
csvfox names.csv -hide[3],[4] firstnames.csv
This command hides the third and fourth column (LastName and Birth) of names.csv from output.
firstnames.csv
CityFirstNameDriver License
RomeAndreay
Los AngelesLieutnanty
LondonHercule-
New YorkTheodorosy
csvfox names.csv -hide[FirstName]-[Birth] nonames.csv
This command hides a range of three columns (FirstName, LastName, and Birth) of names.csv from output.
nonames.csv
CityDriver License
Romey
Los Angelesy
London-
New Yorky

Hint

This command is meant for preventing output of one or a few CSV columns.
If you want to rearrange column output completely, or just write only a few of many columns, consider using ±columns instead.
 

Under construction, coming soon