Find keyword in table

This software find the lines and columns containing a keyword. This software is especially useful before resizing a big table with Resize table

Manual :

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

2- if not already installed, install List::MoreUtils perl package

3- download the program

4- Use this syntax in a GNU linux / Unix terminal type :

NAME

perl find_keyword.pl FILENAME

DESCRIPTION

This software extract some lines and columns in 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.

-h

Give syntax. This argument must be the first.

-help

Give detailed help (print this message). This argument

must be the first.

EXAMPLE

perl find_keyword.pl FILENAME -s ';' # separator ";"

perl find_keyword.pl FILENAME -s ',' # separator ","

This software uses regular expression in the search 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

For more information about regular expressions, visit :

http://perldoc.perl.org/perlre.html

IMPORTANT : search is case sensitive. If unsure you can search [Kk]ey (match for "Keyword" and "keyword") or KEY|key (match for "keyword" or "KEYword" or "keyWORD" or "KEYWORD")

Caution : The end of line used by this software is Unix like : \n. It has been tested only with Unix like files (end of line \n), it should work with windows files (end of line \r\n) and it should not work with Apple files (end of line \r). File conversion is possible with search replace word (see convert Mac or Win file into Unix).