Fsdb::Filter - base class for Fsdb filters River stage zero No dependents

Fsdb::Filter is the virtual base class for Fsdb filters. Users will typically invoke individual programs via the command line (for example, see dbcol(1)) or string together several in a Perl program as described in dbpipeline(3). For new Filter devel...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbrow - select rows from an Fsdb file based on arbitrary conditions River stage zero No dependents

Select rows for which all CONDITIONS are true. Conditions are specified as Perl code, in which column names are be embedded, preceded by underscores....

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbcol - select columns from an Fsdb file River stage zero No dependents

Select one or more columns from the input database. If a value is given for empty columns with the -e option, then any named columns which don't exist will be created. Otherwise, non-existent columns are an error. Note: a safer way to create columns ...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbsort - sort rows based on the the specified columns River stage zero No dependents

Sort all input rows as specified by the numeric or lexical columns. Dbsort consumes a fixed amount of memory regardless of input size. (It reverts to temporary files on disk if necessary, based on the -M and -T options.) The sort should be stable, bu...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbjoin - join two tables on common columns River stage zero No dependents

Does a natural, inner join on TABLE1 and TABLE2 the specified columns. With the "-a" option, or with "-t outer" it will do a natural, full outer join. (Database review: inner joints output records only when there are matches in both tables and will o...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbmerge - merge all inputs in sorted order based on the the specified columns River stage zero No dependents

Merge all provided, pre-sorted input files, producing one sorted result. Inputs can both be specified with "--input", or one can come from standard input and the other from "--input". With "--xargs", each line of standard input is a filename for inpu...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbmerge2 - merge exactly two inputs in sorted order based on the the specified columns River stage zero No dependents

Merge exactly two sorted input files, producing one sorted result. Inputs can both be specified with "--input", or one can come from standard input and the other from "--input". Inputs must have identical schemas (columns, column order, and field sep...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::csv_to_db - convert comma-separated-value data into fsdb River stage zero No dependents

Converts a comma-separated-value data stream to Fsdb format. The input is CSV-format (*not* fsdb). The first row is taken to be the names of the columns. The output is two-space-separated fsdb. (Someday more general field separators should be support...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::db_to_csv - convert fsdb to the comma-separated-value file-format River stage zero No dependents

Covert an existing fsdb file to comma-separated value format. Input is fsdb format. Output is CSV-format plain text (*not* fsdb)....

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbroweval - evaluate code for each row of a fsdb file River stage zero No dependents

Evaluate code for each row of the data. Typical actions are things like reformatting and other data transformations. Code can include embedded column names preceded by underscores; these result in the value of that column for the current row. The val...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbrowdiff - compute row-by-row differences of some column River stage zero No dependents

For a given column, compute the differences between each row of the table. Differences are output to two new columns, "absdiff" and "pctdiff". Differences are either relative to the previous column (*incremental* mode), or relative to the first row (...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::xml_to_db - convert a subset of XML into fsdb River stage zero No dependents

Converts a *very limited* subset of XML into Fsdb format. The input is XML-format (*not* fsdb). The input is parsed as XML, and each entity of type ENTITYFIELD is extracted as a row. ENTITYFIELD can have mutliple components separated by slashes to wa...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbfilecat - concatenate two files with identical schema River stage zero No dependents

Concatenate all provided input files, producing one result. We remove extra header lines. Inputs can both be specified with "--input", or one can come from standard input and the other from "--input". With "--xargs", each line of standard input is a ...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::cgi_to_db - convert stored CGI files (from CGI.pm) to fsdb River stage zero No dependents

Converts all stored CGI files (from CGI.pm) to fsdb, optionally unescaping the contents. When contents are unescaped, CR NL is recoded as ``\n''. Output is always in fsdb list format with double space (type ``S'') field separator. Unlike most Fsdb pr...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbrowuniq - eliminate adjacent rows with duplicate fields, maybe counting River stage zero No dependents

Eliminate adjacent rows with duplicate fields, perhaps counting them. Roughly equivalent to the Unix uniq command, but optionally only operating on the specified fields. By default, *all* columns must be unique. If column names are specified, only th...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::yaml_to_db - convert a subset of YAML into fsdb River stage zero No dependents

Converts a *very limited* subset of YAML into Fsdb format. The input is YAML-format (*not* fsdb). The input is parsed as YAML, assuming the file is an array of dictionary entries. We extract the dictionary names and output this as an fsdb table. The ...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbcolhisto - compute a histogram over a column of Fsdb data River stage zero No dependents

This program computes a histogram over a column of data. Records containing non-numeric data are considered null do not contribute to the stats (optionally they are treated as zeros). Defaults to 10 buckets over the exact range of data. Up to three p...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbrowcount - count the number of rows in an Fsdb stream River stage zero No dependents

Count the number of rows and write out a new fsdb file with one column (n) and one value: the number of rows. This program is a strict subset of dbcolstats. Although there are other ways to get a count of rows ("dbcolstats", or "dbrowaccumulate -C 1"...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbpipeline - allow db commands to be assembled as pipelines in Perl River stage zero No dependents

This module makes it easy to create pipelines in Perl using separate processes. (In the past we used to use perl threads.) By default (as with all Fsdb modules), input is from STDIN and output to STDOUT. Two helper functions, fromfile and tofile can ...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

Fsdb::Filter::dbfilediff - compare two fsdb tables River stage zero No dependents

Dbfilediff compares two Fsdb tables, row by row. Unlike Unix diff(1), this program assumes the files are identical line-by-line and we compare fields. Thus, insertion of one extra row will result in all subsequent lines being marked different. By def...

JOHNH/Fsdb-2.69 - 22 Nov 2019 17:43:00 UTC

54 results (0.026 seconds)