***CAMPAIGN 1998 CONTRIBUTIONS***
---------------------------------------------------------------------------
NAME PHONE Jan | Feb | Mar | Total Donated
---------------------------------------------------------------------------
Mike Harrington (510) 555-1212 250.00 100.00 175.00 525.00
Christian Dobbins (408) 555-1212 155.00 90.00 201.00 446.00
Susan Dalsass (206) 555-1212 250.00 60.00 50.00 360.00
Archie McNichol (206) 555-1212 250.00 100.00 175.00 525.00
Jody Savage (206) 555-1212 15.00 188.00 150.00 353.00
Guy Quigley (916) 555-1212 250.00 100.00 175.00 525.00
Dan Savage (406) 555-1212 450.00 300.00 275.00 1025.00
Nancy McNeil (206) 555-1212 250.00 80.00 75.00 405.00
John Goldenrod (916) 555-1212 250.00 100.00 175.00 525.00
Chet Main (510) 555-1212 50.00 95.00 135.00 280.00
Tom Savage (408) 555-1212 250.00 68.00 200.00 618.00
Elizabeth Stachelin (916) 555-1212 175.00 75.00 300.00 550.00
----------------------------------------------------------------------------
SUMMARY
----------------------------------------------------------------------------
The campaign received a total of $6137.00 for this quarter.
The average donation for the 12 contributors was $511.42.
The highest contribution was $450.00.
The lowest contribution was $15.00.
I wan to get this two out put The highest contribution was $450.00.
The lowest contribution was $15.00
How can I get from the file.
I am able to get all the results but not able to find the last two result
this i got so far
can any one please help me.
Thank you
HI all
I'm trying to write an awk script to print the min and max value in a range(s) contained in another file - the range values are in $2
EG
114,7964,1,y,y,n
114,7965,1,y,y,n
114,7966,1,y,y,n
114,7967,1,y,y,n
114,7969,1,y,y,n
114,7970,1,y,y,n
114,7971,1,y,y,n
114,7972,1,y,y,n... (3 Replies)
hi, i have an awk script and I managed to figure out how to search the max value but Im having difficulty in searching for the min field value.
BEGIN {FS=","; max=0}
NF == 7 {if (max < $6) max = $6;}
END { print man, min}
where $6 is the column of a field separated by a comma (3 Replies)
I have a data file of two columns (corresponding to the x and y axes of a graph) separated by a comma. I want to find the local maximum values and print them to a file. It has been a while since I've done any scripting and I've forgotten everything. I have a few basic questions.
1.) How do... (1 Reply)
Hi guys!
I'm new to scripting and I need to write a script in awk.
Here is example of file on which I'm working
ATOM 4688 HG1 PRO A 322 18.080 59.680 137.020 1.00 0.00
ATOM 4689 HG2 PRO A 322 18.850 61.220 137.010 1.00 0.00
ATOM 4690 CD ... (18 Replies)
Hi guys,
I already search on the forum but i can't solve this on my own.
I have a lot of files like this:
And i need to print the line with the maximum value in last column but if the value is the same (2 in this exemple for the 3 last lines) i need get the line with the minimum value in... (4 Replies)
I feel stupid for asking this because it seems that MYSQL code isn't working the way that I think it should work.
Basically I wrote code like this:
select * from `Test_DC_Trailer` HAVING max(DR_RefKey);
Where the DR_RefKey is a unique numeric field that is auto iterated (like a primary key)... (7 Replies)
- I have two files (File 1 and File 2) and the contents of the files are mentioned below.
- I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2.
- I tried to modify and use... (10 Replies)
Hi,
I need your kind help to get min and max values from file based on value in $5 .
File1
SP12.3 stc 2240806 2240808 + ID1_N003 ID2_N003T0
SP12.3 sto 2241682 2241684 + ID1_N003 ID2_N003T0
SP12.3 XE 2239943 2240011 + ID1_N003 ID2_N003T0
SP12.3 XE 2240077 2241254 + ID1_N003 ... (12 Replies)
I am using the following script to search for and print minimum values for each individual Fields (3-14) for each unique id (Field 1). But when the field contains a "-99.99" ( I am ignoring "-99.99") and when the minimum value is the first line of a new id (Field 1), the output does not print Field... (13 Replies)
Discussion started by: ncwxpanther
13 Replies
LEARN ABOUT PHP
tsi
TSI(5) File Formats Manual TSI(5)NAME
tsi - Transmission Subscriber Identification (TSI) access control list
DESCRIPTION
The HylaFAX configuration parameter QualifyTSI specifies whether or not the identity of a calling facsimile machine should be checked
against an access control list before receiving facsimile. If QualifyTSI is non-null, then only messages from facsimile machines identi-
fied in the file specified by the string (typically etc/tsi) will be accepted.
Patterns are specified one per line and must conform to the regular expressions syntax specified by POSIX 1003.2; see re_format(7). Com-
ments may be included; they are introduced with the ``#'' character and extend to the end of the line. Any trailing white space on a line
is ignored (for convenience when comments are used).
If a line begins with ``!'', then the regular expression identifies clients that should be rejected; otherwise regular expressions identify
clients whose transmissions should be accepted. The order of patterns in a TSI file is important. When a facsimile is to be received, the
fax server will compare the client's TSI against the patterns in the access control list in the order in which they appear in the file.
The first pattern that matches the client TSI is used to decide whether to accept or reject the facsimile. If no patterns match the client
TSI then the facsimile is rejected. Thus if you want to accept all but a restricted set of TSI the last line in the file should be
``^.*$''.
Note that regular expression patterns should be written to match a TSI exactly. That is, patterns should be of the form:
^<pattern>$
where the ``^'' and ``$'' characters are used to specify the start and end of the matching TSI. Additionally, regular expression patterns
should handle white space that may appear in known locations. For example,
^([+]1){1}[ .-]*415[ .-]*555[ .-]*1212.*$
matches the following TSI strings:
+1.415.555.1212
415 555 1212
1-415-555-1212
Finally, note that regular expressions can be used to specify many TSI with one pattern.
NOTES
It would be nice if TSI that were to be matched against were placed in some canonical form (e.g. remove white space and white space-like
characters). This is, however, problematic, because some facsimile machines permit any printable ASCII string to be sent as a TSI.
SEE ALSO faxgetty(8), re_format(7), hylafax-config(5)
December 5, 1994 TSI(5)