App::combinesheets Command-line tool merging CSV and TSV spreadsheets
Download

App::combinesheets Ranking & Summary

App::combinesheets Tags

Perl module perl csv

App::combinesheets Description

App::combinesheets is a command-line tool merging together two or more spreadsheets. The spreadsheets can be COMMA-separated or TAB-separated files, each of them having the first line with column headers. Data in one of the column (it can be a different column in each input spreadsheet) serve to match lines. For example, having two spreadsheets, PERSON and CAR, with the following contents: persons.tsv: Surname First name Sex Age Nickname Novak Jan M 52 Honza Gudernova Jitka F 56 Senger Martin M 61 Tulak cars.tsv: Model Year Owned by Praga 1936 Someone else Mini 1968 Gudernova Skoda 2002 Sengerwe want to merge these spreadsheet by Surname in persons.tsv and by Owned by in cars.tsv. There are two possible results, depending which spreadsheet is used as the first one (a primary one). If the persons.tsv is the first, the result will be (which columns are included in the result will be described later in this document): combinesheets -cfg config.cfg -in PERSON=persons.tsv CAR=cars.csv First name Surname Model Sex Nickname Age Year Owned by Jitka Gudernova Mini F 56 1968 Gudernova Jan Novak M Honza 52 Martin Senger Skoda M Tulak 61 2002 SengerOr, if the cars.tsv is the first, the result will be: combinesheets -cfg config.cfg -in CAR=cars.csv PERSON=persons.tsv First name Surname Model Sex Nickname Age Year Owned by Jitka Gudernova Mini F 56 1968 Gudernova Martin Senger Skoda M Tulak 61 2002 Senger Praga 1936 Someone elseOf course, if both input spreadsheets have only the matching lines, both results will be the same (it will not matter which one of them is considered the primary one).The rows in the resulting spreadsheet are sorted by values in the column that was used as a matching column in the primary input.The information which columns should be used to match the input spreadsheets and which columns should appear in the resulting spreadsheet is read from a configuration file (see the -config - or -cfg - argument).The command-line arguments and options can be specified with single or double dash. Most of them can be abbreviated to the nearest non-biased length. They are case-sensitive.SYNOPSIS combinesheets -h combinesheets -help combinesheets -man combinesheets -version combinesheets -config < config-file > -inputs < input-files > where < input-files > has the form: < input-ID >=< filename > where < options > are: -checkProduct's homepage

App::combinesheets Related Software