Hi All,
I need to select only those records having a non zero record in the first column of a comma delimited file.
Suppose my input file is having data like:
"0","01/08/2005 07:11:15",1,1,"Created",,"01/08/2005"
"0","01/08/2005 07:12:40",1,1,"Created",,"01/08/2005"... (2 Replies)
I'll try explain this as best I can. Let me know if it is not clear.
I have large text files that contain data as such:
143593502 09-08-20 09:02:13 xxxxxxxxxxx xxxxxxxxxxx 09-08-20 09:02:11 N line 1 test
line 2 test
line 3 test
143593503 09-08-20 09:02:13... (3 Replies)
Hi all!
A bit of background: I am trying to create a script that formats SQL statements. I have gotten so far as to add new lines based on certain match criteria like commas, keywords etc. In the process, I end up adding newlines where I don't want.
For example: substr(colName, 1, 10)... (3 Replies)
Hello,
Need help with following scenario.
A file contains following text:
{beginning of file}
New: This is a new record and it is not
on same line. Since I have lost touch with script
take this challenge and bring all this in one line.
New: Hello losttouch. You seem to be struggling... (4 Replies)
Hi,
I would like to know how can I select lines of one file based on a common ID column from another file (keeping the order of the second file).
Example of file1:
ID A B C D
1-30 1 2 3
5-60 4 5 6
1-20 7 8 9
Example of file2:
ID chr pos
1-20 1 20
1-30 1 30
5-60 5 60
Desired... (2 Replies)
I have a file.....
xxx 2345 455
abc 345 555
cdf 456 777
fff 555 888
Now my requirement is, Say if, i want to select only those records prior to the record fff 555 888...
how do i go about doing this in unix....
The fff would be hardcoded as it wud be fixed and everytime when i... (7 Replies)
Hello,
I use UBUNTU 12.04.
I want to write a short program using awk to select some lines in a file based on a second file.
My first file has this format with about 400,000 lines and 47 fields:
SNP1 1 12.1
SNP2 1 13.2
SNP3 1 45.2
SNP4 1 23.4
My second file has this format:
SNP2
SNP3... (1 Reply)
Hi All,
I have following input file. I wish to retain those lines which match multiple search criteria. The search criteria is stored in a variable seperated from each other by comma(,).
SEARCH_CRITERIA = "REJECT, DUPLICATE"
Input File:
ERROR,MYFILE_20130214_11387,9,37.75... (3 Replies)
Hello,
I have two files of the following form. I would like to remove from File.A where the first three colum matches values in File.B to give the output in File.C
File.A
121 54321 PQR CAT
122 765431 ABC DOG
124 98765 ZXY TIGER
125 86432 GEF LION
File.B
122 765431 ABC
125 86432 GEF... (4 Replies)
Discussion started by: Gussifinknottle
4 Replies
LEARN ABOUT DEBIAN
fullquottel
FULLQUOTTEL(1) User Commands FULLQUOTTEL(1)NAME
fullquottel - tool for detecting full quotes in mails or postings
SYNOPSIS
fullquottel [OPTION...] < infile > outfile
DESCRIPTION
fullquottel - tool for detecting full quotes in mails or postings
-t, --scorethreshold=NUMBER
Threshold for final score that discriminates between Goodquottel and Fullquottel (default: 1.5)
--quotechars=CHARS
Chars used for quoting (default: >|#)
-d, --debug
Debug option (prints single test results; default: off)
--ownsigtest=1|0
Turn on/off ownSigTest (default: on)
--ownsigtestscore=NUMBER
Score for ownSigTest (default: 1.0)
-f, --ownsigtestfile=SIGFILE
Signature file to test against (default: ~/.signature)
--mstest=1|0
Turn on/off msTest (Microsoft attribution lines; default: on)
--mstestscore=NUMBER
Score for msTest (default: 1.0)
--mstestthreshold=NUMBER
Threshold for msTest (at or below which line a Microsoft attribution line ist found; default: 2)
--quotedtoalltest=1|0
Turn on/off quotedToAllTest (ratio quoted lines to all; default: on)
--quotedtoalltestscore=NUMBER
Score for quotedToAllTest (default: 1.0)
--quotedtoalltestfactor=NUMBER
Result = score + ratio * FACTOR (default: 0)
--quotedtoalltestthreshold=NUMBER
Ratio threshold for activating quotedToAllTest (default: 0.5)
--bottomquotedtoalltest=1|0
Turn on/off bottomQuotedToAllTest (ratio quoted lines at bottom to all; default: on)
--bottomquotedtoalltestscore=NUMBER
Score for bottomQuotedToAllTest (default: 1.0)
--bottomquotedtoalltestfactor=NUMBER
Result = score + ratio * FACTOR (default: 0)
--bottomquotedtoalltestthreshold=NUMBER
Ratio threshold for activating bottomQuotedToAllTest (default: 0.5)
--bottomquotedtoquotedtest=1|0
Turn on/off bottomQuotedToQuotedTest (ratio quoted lines at bottom to all quoted lines; default: on)
--bottomquotedtoquotedtestscore=NUMBER
Score for bottomQuotedToQuotedTest (default: 1.0)
--bottomquotedtoquotedtestfactor=NUMBER
Result = score + ratio * FACTOR (default: 0)
--bottomquotedtoquotedtestthreshold=NUMBER
Ratio threshold for activating bottomQuotedToQuotedTest (default: 0.5)
--singlebottomquotetest=1|0
Turn on/off singleBottomQuoteTest (only one quote block, and at the bottom; default: on)
--singlebottomquotetestscore=NUMBER
Score for singleBottomQuoteTest (default: 1.0)
HINT: All long options (without leading --) can be used in ~/.fullquottelrc
-?, --help
Give this help list
--usage
Give a short usage message
-V, --version
Print program version
Mandatory or optional arguments to long options are also mandatory or optional for any corresponding short options.
REPORTING BUGS
Report bugs to <toast@toastfreeware.priv.at>.
SEE ALSO
The full documentation for fullquottel is maintained in HTML created by doxygen and can be found in
/usr/share/doc/fullquottel/html/
fullquottel 0.1.2 April 2007 FULLQUOTTEL(1)