view release on metacpan or  search on metacpan

bin/db-browser  view on Meta::CPAN

Remove rows with all fields empty or undefined (Includes completely empty rows).

=item Empty Columns

This filter has two menu entries:

Remove completely empty columns. (Columns with all rows empty or undefined)

Remove columns without data. (Columns where a header may exist, but all data rows are empty or undefined)


=item Remove Cell

Remove a cell from a chosen row.

=item Insert Cell

Insert a cell in a chosen row. The new cell is inserted in front of a chosen cell.

=item Append Col

Append an empty column. Appends a header element to the header row and adjusts the remaining rows to the length of the
header row. If the input has rows with different numbers of cells, use the I<Row Group> filter first to select the right
row-group.

=item Split Column

     Item | length/width/height             Item | length | width | height
    ------|---------------------            -----|--------|-------|------
      423 |            40/30/25              423 |     40 |    30 |    25
    ------|---------------------            -----|--------|-------|------
       64 |            80/60/30               64 |     80 |    60 |    30
    ------|---------------------            -----|--------|-------|------
      705 |            50/50/40              705 |     50 |    50 |    40

=item Search & Replace

I<s/Pattern/Replacement/Modifiers>

Remove all commas: C<s/,//g>

    id | num                       id | num
    ---|-------------              ---|-----------
     1 |    78,975.17               1 |   78975.17
    ---|-------------              ---|-----------
     2 | 1,040,745.87               2 | 1040745.87
    ---|-------------              ---|-----------
     3 | 3,129,818.21               3 | 3129818.21

Supported L<modifiers|https://perldoc.perl.org/perlre#Modifiers>: C<imnsxage>.

In the replacement, the variable C<$c> can be used as a counter. C<$c> is set to C<0> before each C<s///>.

By selecting the prompt line (I<Your choice:>), one can save I<search & replace> instructions for later use.

If a I<search & replace> has altered the first row of the input data, a menu entry named C<RESTORE header row> is
offered.


=item Convert DateTime

Convert a I<DateTime> to another format or to seconds since the Unix epoch.

    id | date_time                            id | date_time
    ---|----------------------------          ---|--------------------
     1 | Sat 13 Aug 2022 07:38:49 PM           1 | 2022-08-13 19:38:49
    ---|----------------------------          ---|--------------------
     2 | Mon 15 Aug 2022 12:08:54 PM           2 | 2022-08-15 12:08:54
    ---|----------------------------          ---|--------------------
     3 | Tue 16 Aug 2022 09:56:13 AM           3 | 2022-08-16 09:56:13

=item Split Table

     y  | factor | y  | factor              y  | factor
    ----|--------|----|--------             ---|-------
     62 | 8975.1 | 64 | 9986.5              62 | 8975.1
    ----|--------|----|--------             ---|-------
     63 | 9745.8 | 65 | 9782.7              63 | 9745.8
                                            ---|-------
                                            y  | factor
                                            ---|-------
                                            64 | 9818.2
                                            ---|-------
                                            65 | 9986.5

=item Merge Rows

     Month | Average | Average              Month | Average MinTemp | Average MaxTemp
    -------|---------|---------             ------|-----------------|----------------
           | MinTemp | MaxTemp              Jan   |               9 |              22
    -------|---------|---------             ------|-----------------|----------------
     Jan   |       9 |      22              Feb   |              10 |              23
    -------|---------|---------
     Feb   |      10 |      23

I<Merge Rows> can be used to edit a row by selecting only one row.

=item Join Columns

     Item | length | width | height          Item | length/width/height
    ------|--------|-------|--------         -----|-------------------
      423 |     40 |    30 |     25           423 | 40/30/25
    ------|--------|-------|--------         -----|-------------------
       64 |     80 |    60 |     30            64 | 80/60/30
    ------|--------|-------|--------         -----|-------------------
      705 |     50 |    50 |     40           705 | 50/50/40

I<Join Columns> can be used to edit a column by selecting only one column.

=item Fill up Rows

If the input table rows have different numbers of cells, this filter appends empty cells to the rows until the cell
count of each row is equal to the cell count of the row with the highest cell count.

You can enter the I<Row Group> filter to check if the table has rows with different lengths. If I<Row Group> shows only
one group, all rows have the same length.

=item Cols to Rows

Transpose columns to rows.

     Year | 2000 | 2001 | 2002              Year | Max | Min