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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbcolstats - compute statistics on a fsdb column River stage zero No dependents

Compute statistics over a COLUMN of data. Records containing non-numeric data are considered null do not contribute to the stats (with the "-a" option they are treated as zeros). Confidence intervals are a t-test (+/- (t_{a/2})*s/sqrt(n)) and assume ...

JOHNH/Fsdb-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbformmail - write a shell script that will send e-mail to many people River stage zero No dependents

Read a ``form mail'' message from the file FORMAT_FILE.TXT, filling in underscore-preceded column-names with data. Output a shell script which will send each message through some mail transport MECHANISM. Do not use this program for evil or I will ha...

JOHNH/Fsdb-2.68 - 19 Sep 2019 15:23:50 GMT

Fsdb::Filter::dbcolmerge - merge multiple columns into one River stage zero No dependents

For each row, merge multiple columns down to a single column, joining elements with ElementSeparator (defaults to a single underscore)....

JOHNH/Fsdb-2.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

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.68 - 19 Sep 2019 15:23:50 GMT

54 results (0.033 seconds)