Skip to content

muir/tsv.pl

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

NAME
     tsv - general tsv file mangler

USAGE
     tsv [options] file(s)

OPTIONS
     --show                 Display column names
     -f --cut COL,COL,COL   like cut(1) but uses column names
     --rotate               Turn columsn to rows
     --matchup FILE         Rotate, grabbing header from FILE
     --validate             Discards rows that have wrong column count
     -n --head COUNT        Only process COUNT lines
     --default VALUE        Replace empty values with VALUE
     --grep COLS PATTERN    Search for pattern in cols
     --select COLS CODE     Eval code on cols, output if returns true
     --help                 Display man page

DESCRIPTION
    tsv is a collection of small tools for manipulating and reporting on TSV
    (tab separated values) files.

    --show
        Displays a numbered list of the columns

    --cut COLUMN_NAME(S)
        Outputs a new TSV with just the named columns. Columns must be
        named; separate column names with comma ",".

    --rotate
        Turn the columns into rows and the rows into columns.

    --matchup FILE
        Grab the first row from FILE and then rotate STDIN. Usually this is
        used when with grep:

         grep stuff file.tsv | tsv --match file.tsv

    --grep COLUMNS PATTERN
        Look for PATTERN in COLUMNS (comma separate list, names or numbers)

    --select CODE
        Evaluate CODE. The first row of the data must be column names. The
        input will be split and assigned to variables named by the column
        names: if there is a column named "best before", then there will be
        a variable $best_before that has the data corresponding to the "best
        before" column for that row. The entire row will be in $_. The first
        row will always print since it's a header. A true value from the
        code will cause the line to print. Do not use "return": the code is
        inside a while loop, not a sub.

    --validate
        Only output rows that have the same number of columns as the header
        line.

    --default VALUE
        Replace empty values with VALUE. This can be combined with
        --validate. This will not pad the number of columns to match the
        header.

    -n --head COUNT
        Only process until there are COUNT lines of data output. This can be
        combined with all the other options except --show. The header does
        not count towards the count.

LICENSE
    Copyright (C) 2008, 2009 David Sharnoff. Copyright (C) 2013 Google, Inc.

    This package may be used and redistributed under the terms of either the
    Artistic 2.0 or LGPL 2.1 license.

About

tsv command on CPAN -- slices and dices TSV files

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages