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).