07-02-2008
selective printing awk
Hi there
my file looks like this
1 a b c d e f
2 a b b c d e f f g h e t t
3 a c b d e f
4 a b c
i want to print the line which has the fields containing ONLY a b c, in this case the line 4.
How can i awk it !!!?
Many Thanks in advance!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all , i need to grep for a string in a text file and print the string and the 3rd line above it.
As always , Thanks. (4 Replies)
Discussion started by: okiedokie
4 Replies
2. Shell Programming and Scripting
Hi
I have a folder that contain up to 1000 subfolder. Genereally i need just 2 or 3 of them and i can know apriori the name of the subfolder i want to keep.
I'd like to erase all the unnecessary subfolders.
I've tried with:
ls -l | awk '$8 !~ /name_fold/{print "rm -r " $8}'| sh
and it... (4 Replies)
Discussion started by: Dedalus
4 Replies
3. Shell Programming and Scripting
Hi,
I have an xml file having serveral smiliar lines as below
<INPUT VAR1 ="" DATATYPE ="number(p,s)" VAR2 ="" VAR3 ="3" VAR4="0" VAR5 ="ELEMITEM" VAR6 ="NO" VAR7 ="NOT A KEY" VAR8 ="17" LEVEL ="0" NAME ="UNIX" NULLABLE ="NOTNULL" OCCURS ="0" OFFSET ="19" PHYSICALLENGTH ="15"... (3 Replies)
Discussion started by: dips_ag
3 Replies
4. Shell Programming and Scripting
Hi,
i need help to print number from different field
INPUT:
Student1 10 20
Student2 30 40
Student3 50 60
Student4 70 80
Desired Output:
1 20-30
2 40-50
3 60-70
Thank you! (5 Replies)
Discussion started by: saint2006
5 Replies
5. Shell Programming and Scripting
Hi,
I have a file with lines like this.
2 7 18 ggcgt anna
2 7 18 hhchc sam
3 7 18 hhdjcc ross
4 7 18 hhcjd jenny
0 8 21 jjdhs sam
3 8 21 kkok bush
2 9 24 kosss BrenhamIf the values of the second column are equal, print only those lines with the least first column value. So in... (5 Replies)
Discussion started by: polsum
5 Replies
6. Shell Programming and Scripting
hi all
from below text
"abcd,SYS_12345,xyz,PQR, ,"
I want to print only
"abcd,SYS,xyz,PQR, ,"
i.e. taking only first three 3 chars from 2 string of comma separated file
thanks (4 Replies)
Discussion started by: JoeColeEPL9
4 Replies
7. Shell Programming and Scripting
I have the following contents in a file
---- CRITICAL: altered for /usr/bin/bin1 ---- OK: /usr/sbin/bin2 result fine ---- OK: /usr/sbin/bin3 result fine ---- CRITICAL: altered for /usr/bin/bin4 ---- OK: /usr/bin/bin5 result fine ---- OK: /usr/bin/bin6 result fine ---- CRITICAL: altered for... (9 Replies)
Discussion started by: anil510
9 Replies
8. Shell Programming and Scripting
Hi,
I have file with thousands of lines somewhat similar to the below 6 lines
06MXXXXXXXXXXXXXXXX 0328 003529 J27300022 MICROSOFT *MSN
06<1 000000001344392 JPN151-85830 MSBILL.INFO F
06<A17087454000328651551 MSBILL.INFO ... (16 Replies)
Discussion started by: dsid
16 Replies
9. Shell Programming and Scripting
Hi Gurus,
I have following input file. I tried multiple awk combinations to print selected columns without success.
HEX ID Name ver FLRGT Start Time Total Shared End Date
----- -------- --- ------ ------------------------ -------------- -------... (4 Replies)
Discussion started by: shunya
4 Replies
10. UNIX for Beginners Questions & Answers
I apologize in advance, but I continue to have trouble searching for matches between two files and then printing portions of each to output in awk and would very much appreciate some help.
I have data as follows:
File1
PS012,002 PRQ 0 1 1 17 1 0 -1 3 2 1 2 -1 ... (7 Replies)
Discussion started by: jvoot
7 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-jn m Join on the mth field of file n. If n is missing, use the mth field in each file.
-o list
Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1)
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
7th Edition April 29, 1985 JOIN(1)