Resize table

With this software you can select lines and columns of a large table and export them in a resized table. You may want to use Look inside file or Find keyword in table before resizing a big table.

The size of the table is only limited by the place on the hard disk, so you can resize very large file with any computer. The software can also process an unlimited number of files, provided that you want to export the same lines and columns. This is especially useful to extract numerical data of a large table.

Manual :

1- if not already installed, install Perl free programming language.

2- The program also use Tie::File but this module is generally installed by default (at least on linux).

3- unzip the software

4- copy your tables files in the “data” directory. By default the software uses - txt or csv files with TAB separator.

if you want to use another separator, use this syntax in a GNU linux / Unix terminal or in windows command line : perl resize-table.pl -s 'separator'

EXAMPLES

perl resize-table.pl -s ';' # separator ";"

perl resize-table.pl -s ',' # separator ","

The program asks you to select lines and columns. Numbers can be separated by ",", a range of number is X-Y, to start from X to the end, type X-end, to select all, just type <enter>.

Example : 1,5-10,15-end

select the lines : 1,5,6,7,8,9,10,15...end

interval selection is possible with include function : inc(start;end;step)

inc(6;13;3) => 6 9 12

inc(6;end;3) => 6 9 12 15 ... end

the include function can be of course combined with other selection :

1-5,inc(10;20;3),30-end

Caution : using <end> instead of a number will slow computation on very large files because a line count has to be done before starting to parse the file.