Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Hello there.
I've got the query like that
SELECT count(tour_id) AS cnt
FROM orders
JOIN tours
ON orders.tour_id=tours.id
GROUP BY tour_id
The result Is
cnt
1
4
2
1
1
Now i have to select all records with minimum values in field "cnt"
MySQL function min() returns only one.... (2 Replies)
Hi all,
I am having multiple files with the pattern given below:
I need to find the minimum value of 5th column if column 1 is x and 2nd column is awh or vbn or ... (20 different strings).
the output must be like:
Kindly help me to figure out this prob....
Thanks in... (4 Replies)
Hi All,
I have multiple files which contains 5 columns and multiple rows.....
I want to calculate the minimum value of column 5th, if column 2 is MET, till column 1 comes to the next number.
Also it must skip the condition similar to 1st line where column number 1 and 3 are same and... (9 Replies)
I have two LARGE files of data more than 20,000 line each, file-1 and file-2, and I wish to do the following if possible:
file-1
1 2 5 7 9
2 4 6 3 8 9
4 6 8 9 3 2 1 3
1 2
.
.
.
file-2
1 2 3
2 5 7
5 7 3
7 9 4
. (5 Replies)
Deal All,
I have millions of input file like this:
input 1:
disk minimum
DISK01 5173
DISK02 5227
DISK03 5284
DISK04 5346
DISK05 5400
DISK06 5456
DISK07 5511
DISK08 5572
.
.
.
input 2:
range 5180-5300 (3 Replies)
I am trying to find the minimum maximum and average from one file which has values
Received message from https://www.demandmatrix.net/app/dm/xml] in milliseconds.
Received message from https://www.demandmatrix.net/app/dm/xml] in milliseconds.
Received message from... (5 Replies)
input
1 2 3 4 5 2 8
2 1 1 1 4 2 1
5 4 4 4 2 1 3
2 2 6 7 4 5 4
5 5 5 4 3 3 5
I woud like to print a min of each row such that my output would look like
1
1
1
2
3 (5 Replies)
I have a fixed length file and I want to find out row number along with row length.
I have a program that give me the line length if it satisfy the condition; but i would like to add row number as well?
How do I do that?
while IFS= read -r line; do
if ; then
echo ${line}
echo... (8 Replies)
Discussion started by: princetd001
8 Replies
LEARN ABOUT DEBIAN
igawk
IGAWK(1) Utility Commands IGAWK(1)NAME
igawk - gawk with include files
SYNOPSIS
igawk [ all gawk options ] -f program-file [ -- ] file ...
igawk [ all gawk options ] [ -- ] program-text file ...
DESCRIPTION
Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).
AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like
@include getopt.awk
in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.
OPTIONS
See gawk(1) for a full description of the AWK language and the options that gawk supports.
EXAMPLES
cat << EOF > test.awk
@include getopt.awk
BEGIN {
while (getopt(ARGC, ARGV, "am:q") != -1)
...
}
EOF
igawk -f test.awk
SEE ALSO gawk(1)
Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.
AUTHOR
Arnold Robbins (arnold@skeeve.com).
Free Software Foundation Nov 3 1999 IGAWK(1)