Check Table

This software searches for special characters ('"', '’', '\'', '\/', '\\\\' , '\+' , '\*' , '%', '@', '\^', '\r') in the first column of a table (except or including header) and displays cells that are not numbers. Check Table also detects empty rows and check the number of columns and duplicates in row names.

Manual :

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

2- The program uses Scalar::Util - (on linux, just type <sudo cpan> and then <install Scalar::Util>)

3- unzip the software

4- copy your tables text (or csv) files in the “data” directory

5- execute the software by the command : perl software_name or double click on the .pl file

By default the program will skip the first line (and the first column to check numbers only).

perl check_table-0.3.pl -help

NAME

check_table-xx.pl

DESCRIPTION

This software check tables in CSV or TXT (separator TAB by default).

AUTHOR

Frederic PONT

OPTIONS

-s separator

Specify the separator of the table. If the separator is omitted, tabulation

will be used by default.

-n number

number of lines to skip in header

-c number

number of columns of rownames to skip

-h

Give syntax. This argument must be the first.

-help

Give detailed help (print this message). This argument

must be the first.

EXAMPLE

perl check_table-0.2.pl -s ';' # separator ";"

perl check_table-0.2.pl -s ',' -n 0 # separator "," no header

6- results are in "results" directory.

To change the characters detected by the sofware, edit line 25 :

my @char = ('\'', '\/', '\\\\' , '\+' , '\*' , '%', '@', '\^', '\r') ;

To analyse big tables with a lot of 'NA', choose check_table_skip_NA-0.x.pl

download