The Perl Advent Calendar needs more articles for 2022. Submit your idea today!

Search results for "module:Fsdb::Filter"

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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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 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.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 UTC

Fsdb::Filter::dbcoltype - define (or redefine) types for columns of an Fsdb file River stage zero No dependents

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.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 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-3.1 - 24 Nov 2022 06:25:46 UTC

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

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

JOHNH/Fsdb-3.1 - 24 Nov 2022 06:25:46 UTC

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-3.1 - 24 Nov 2022 06:25:46 UTC

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-3.1 - 24 Nov 2022 06:25:46 UTC
55 results (0.053 seconds)