Search results for "module:Fsdb::Filter"
Fsdb::Filter - base class for Fsdb filters
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbrow - select rows from an Fsdb file based on arbitrary conditions
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbcol - select columns from an Fsdb file
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbjoin - join two tables on common columns
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbsort - sort rows based on the the specified columns
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbmerge - merge all inputs in sorted order based on the the specified columns
Merge all provided, pre-sorted input files, producing one sorted result. Inputs can both be specified with "--input", or with "--inputs", or one can come from standard input and the other from "--input". With "--xargs", each line of standard input is...
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbmerge2 - merge exactly two inputs in sorted order based on the the specified columns
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::xml_to_db - convert a subset of XML into fsdb
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::cgi_to_db - convert stored CGI files (from CGI.pm) to fsdb
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbfilecat - concatenate two files with identical schema
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbrowuniq - eliminate adjacent rows with duplicate fields, maybe counting
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::csv_to_db - convert comma-separated-value data into fsdb
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbrowdiff - compute row-by-row differences of some column
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbcoltype - define (or redefine) types for columns of an Fsdb file
Define the type of each column, where COLUMN and TYPE are pairs. Or, with the "-v" option, redefine all types as string. The data does not change (just the header)....
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbroweval - evaluate code for each row of a fsdb file
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::db_to_csv - convert fsdb to the comma-separated-value file-format
Covert an existing fsdb file to comma-separated value format. Input is fsdb format. Output is CSV-format plain text (*not* fsdb)....
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbfilediff - compare two fsdb tables
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbformmail - write a shell script that will send e-mail to many people
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-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::yaml_to_db - convert a subset of YAML into fsdb
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. We a...
JOHNH/Fsdb-3.4 - 06 Jan 2024 06:43:43 UTC
Fsdb::Filter::dbcolstats - compute statistics on a fsdb column
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-3.4 - 06 Jan 2024 06:43:43 UTC