Select lines in table

This software select rows in a CSV tables (TAB separator) where the first column corresponds to the list in reference files. The first line (table header) is not removed. Since version 0.6, unlimited number of lists and tables can be processed. To process a long reference list, a faster alternative in Julia is Select lines by Regex in table Julia . To remove line, use Remove Lines

Manual :

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

2- unzip the software

3- copy your data csv (TAB separator) table in the “table” directory.

4- copy your reference lists in the “lists” directory, one item per line.

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.

Important remarks :

1- to increase speed, the software assume that there are no duplicates in the 1st column.

if you have duplicates, use select_lines_0.8_dup.pl or comment the line 157 of the Perl program: # splice(@names,$i , 1) ;

2- the software search an exact correspondence between the list and the 1st column of the table. If you want to select lines by keywords, use select_lines_0.8_dup_kw.pl or replace line 172 : if ($line =~ /^\Q$valeur\E$separator/) { by if ($line =~ /\Q$valeur\E/) {

select_lines_0.8_dup.pl : version with duplicates allowed in both data and list - exact search in 1st column

select_lines_0.8_dup_kw.pl : version with duplicates allowed in both data and list - keyword search by lines

select_lines_0.8_dup_REGEX : version with duplicates allowed in both data and list - REGEX search by lines