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