Remove columns

This software removes columns of tables in CSV. The criteria to remove columns is based on the name of the column and/or the index of the column. This software is complementary to Extract Colums.

Manual :

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

2- unzip the software

3- copy your data csv (TAB separator by default) tables in the “table” directory. (unlimited number of tables).

4- Edit the file criteria.pl to match your criteria. The number of criteria is unlimited.

name : regular expression matching the name of the column

condition : can be >, < or '' (no condition)

index : column number

This software uses regular expression in the name pattern

. Match any character (except newline)

* Match 0 or more times

+ Match 1 or more times

? Match 1 or 0 times

\ Quote the next metacharacter

\t tab (HT, TAB)

\n newline (LF, NL)

\s space

\r return

\. dot

Example :

very important : column index start at 0. So index < 2 means that the first and the second column will be removed.

my @exclude_criteria = (

# match columns named exactly "Peptide" with index > 3

{ "name" => '^Peptide$',

"condition" => ">",

"index" => "3",

},

# match columns containing "RT" with index < 5

{ "name" => 'RT',

"condition" => "<",

"index" => "5",

},

# match all columns with index < 10

{ "name" => '.*',

"condition" => "<",

"index" => "10",

}

) ;

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

The program select in the table, the lines which begin by the same string than in the list.

6- processed files are in the “results” directory.