09-14-2006
if you are in windows platform and u have MS excel then i can suggest u something
open excel file-> open the csv file with excel-> then in excel go to -> data->filter->autofilter
then u can go and select the non-blanks from 1,2,3,4,5,6,10,11....if the count is different then there is something missing....
but this will only work f ur csv is small ....i.e not more than 5 mb....or lese u have to resolve it by script....i am working on it...will post later
7 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have a script in sh. with awk, e.g. want to list all the contents of a subdirectory an a tabular way.
ej: outoput
directory1
subdirectory1 subdirectory2 subdirectory3
file1 filen file2 filez
file2 ... filen+1 ... (1 Reply)
Discussion started by: alexcol
1 Replies
2. IP Networking
I volunteer with a small charity which locally donates refurbished computers to people who normally could not afford their own computer. Most of these computers now have Linux on them. We are in the process of remastering Xubuntu 9.04 to use as our main distro from now on.
In the past any time... (3 Replies)
Discussion started by: lagagnon
3 Replies
3. Shell Programming and Scripting
Hi All,
I need some help to effectively parse out a subset of results from a big results file.
Below is an example of the text file. Each block that I need to parse starts with "reading sequence file 10.codon" (next block starts with another number) and ends with **p-Value(s)**. I have given... (1 Reply)
Discussion started by: Lucky Ali
1 Replies
4. Shell Programming and Scripting
hi,
i have a file where I want to extract the the failure count only from the file.
JOB_NAME STATE RUN_COUNT FAILURE_COUNT
------------------------------ --------------- ---------- -------------
OFS_BALA_BILLING_IN SCHEDULED 22992 ... (6 Replies)
Discussion started by: gotam
6 Replies
5. Shell Programming and Scripting
Hello,
I am working on an Urdu to Hindi dictionary which has the following structure:
a=b
a=c
n=d
n=q
and so on.
i.e. Headword separated from gloss by a =
I am giving below a live sample
بتا=बता
بتا=बित्ता
بتا=बुत्ता
بتان=बतान
بتان=बितान
بتانا=बिताना
I need the following... (3 Replies)
Discussion started by: gimley
3 Replies
6. Shell Programming and Scripting
Good Evening,
i got a homework where i have to list all files in the directory with the name length >=3 and <= 6 and after trying it for 2 days my Prof gave me a bit of code:
#!/bin/bash
for file in $(ls)
do
done
after that he told me "now you only have to use wc and you got it" but... (1 Reply)
Discussion started by: Mentoss
1 Replies
7. UNIX for Dummies Questions & Answers
e.g.
File name: File.txt
cat File.txt
Result:
#INBOUND_QUEUE=FAQ1
INBOUND_QUEUE=FAQ2
I want to get the value for one which is not commented out.
Thanks, (3 Replies)
Discussion started by: Tanu
3 Replies
LEARN ABOUT OSF1
mailstats
mailstats(8) System Manager's Manual mailstats(8)
NAME
mailstats - Displays statistics about mail traffic
SYNOPSIS
mailstats [-o] [-C cffile [-f stfile]
FLAGS
Do not display the name of the mailer in the output. Use cffile as the name of the sendmail "cf" file instead of /var/adm/sendmail/send-
mail.cf. Use stfile as the input statistics file instead of /var/adm/sendmail/sendmail.st.
DESCRIPTION
The mailstats command reads the information in the /var/adm/sendmail/sendmail.st file (or in the file specified with the -f flag), formats
it, and writes it to standard output. Note also that you can change the location of the sendmail.st file by editing its pathname in the
sendmail.cf file.
EXAMPLES
The format of the information is shown in the following example, in which the first field (M) contains a number that indicates the position
of that mailer in the sendmail.cf file, starting at 0 (zero). For example, the first mailer in the sendmail.cf file corresponds to the
number 0 in the mailstats display, the second mailer corresponds to the number 1, and so on. Statistics from Thu Feb 17 11:20:01 2000 M
msgsfr bytes_from msgsto bytes_to msgsrej msgsdis Mailer 1 50 77K 1 3K 0 0 local 6
43 59K 58 99K 0 0 smtp ============================================================ T 93
136K 59 102K 0 0 The fields in the report have the following meanings: Indicates the position of the mailer in
the sendmail.cf file. Indicates the number of messages received by the local machine from the indicated mailer. Indicates the number of
bytes in the messages received by the local machine from the indicated mailer. Indicates the number of messages sent from the local
machine using the indicated mailer. Indicates the number of bytes in the messages sent from the local machine using the indicated mailer.
Indicates the number of rejected messages. Indicates the number of discarded messages. Indicates the name of the mailer.
If sendmail transmits mail directly to a file, such as the dead.letter file or an alias target, the message and byte counts are credited to
the prog mailer, as defined in the sendmail.cf file. However, mailstats will still default to var/adm/sendmail/sendmail.st.
FILES
Specifies the command path Contains system statistics Contains configuration information for sendmail
RELATED INFORMATION
Commands: sendmail(8) delim off
mailstats(8)