03-22-2009
Quote:
Originally Posted by
ldapswandog
I joined this forum to learn more ways to do things using sed and awk. I'm going to break this out and cfajohnson can correct me as needed.
awk # call awk utility
-F: # break line into fields using colon as a delimiter
'/^goldsi/ # search for lines begining with goldsi
&& substr($1,7,2) ~ /j/ # AND containing a 'j' in positions 7 or 2 of field 1
&& $4 == 200' # AND containing 200 in field 4
passwd # in file passwd
Hi, idapswandog.
Thanks for the explaination.
But the line below I am not quite agree with you.
&& substr($1,7,2) ~ /j/ # AND containing a 'j' in positions 7 or 2 of field 1
This line might mean get a substring from field 1 at position 7 for 2 characters long.
-Keyang
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
guys,
my requirment goes like this:
I have a file, and wish to filter out records where
1. The first letter is o or O
and
2. The next 4 following letter should not be ther
I do not wish to use pipe and wish to do it in one shot.
The best expression I came up with is:
grep ^*... (10 Replies)
Discussion started by: RishiPahuja
10 Replies
2. UNIX for Advanced & Expert Users
When i do ls -ld RT_BP* i am getting the following list.
drwxrwx--- 2 user group 256 Oct 17 10:09 RT_BP809
drwxrwx--- 2user group 256 Oct 17 10:09 RT_BP809.O
drwxrwx--- 2 user group 256 Oct 17 10:09 RT_BP810
drwxrwx--- 2user group 256 Oct... (2 Replies)
Discussion started by: ukatru
2 Replies
3. Shell Programming and Scripting
please can someone tell me what the following regrex means
grep "^aa*$" <file>
I thought this would match any word beginning with aa and ending with $, but it doesnt.
Thanks in advance
Calypso (7 Replies)
Discussion started by: Calypso
7 Replies
4. UNIX for Dummies Questions & Answers
I have the following code:
ls -al /bin | tr -s ' ' | grep 'x'
ls -al: Lists all the files in a given director such as /bin
tr -s ' ': removes additional spaces between characters so that there is only one space
grep 'x': match all "x" characters that are followed by a whitespace.
I was... (3 Replies)
Discussion started by: MykC
3 Replies
5. Shell Programming and Scripting
Hi,
I am executing a svnlook command to check to see if the following line exists. I need a regular expression to represent the line.
A /test/test1/qa/test2/index.html
A /test/test1/qa/test3/test.jpg
A /test/test1/qa/test3/test1.jpg
A /test/test1/qa/test4/test.swf
I just need to extract... (9 Replies)
Discussion started by: kminkeller
9 Replies
6. Shell Programming and Scripting
Hi,
Input file:
-13-
-1er-
-1xyz1-
-1xz12-
-2ab1-
-2ab2--
-143-
Code:
grep '^*\-' input.txt
Wrong output:
-13-
-1xyz1-
-2ab1-
-2ab2-- (4 Replies)
Discussion started by: dragon.1431
4 Replies
7. Programming
Hi all,
How am I read a file, find the match regular expression and overwrite to the same files.
open DESTINATION_FILE, "<tmptravl.dat" or die "tmptravl.dat";
open NEW_DESTINATION_FILE, ">new_tmptravl.dat" or die "new_tmptravl.dat";
while (<DESTINATION_FILE>)
{
# print... (1 Reply)
Discussion started by: jessy83
1 Replies
8. UNIX for Dummies Questions & Answers
i have a command line like this in csh script
grep -i "$argv$"
which i wanted to select the line ending with string provided as argument but it couldn't interpret the '$' (ending with)..
any help? (3 Replies)
Discussion started by: ymc1g11
3 Replies
9. Shell Programming and Scripting
Hi ,
I have few lines like
A20120101.ANU.ZIP
A20120401.ABC.ZIP
A20120105.KJK.ZIP
A20120809.JUG.ZIP
A20120101.MAT.ZIP
B20120301.ANU.XIP
I want to filter by
1. Files starting with A and Ending With Z ( ^A.*.ZIP$)
2. And either ANU, or KJK or MAT in the file name.
Hope my... (6 Replies)
Discussion started by: Anupam_Halder
6 Replies
10. UNIX for Beginners Questions & Answers
I want to track only below:
I am using below, but it doesn't work: (6 Replies)
Discussion started by: proactiveaditya
6 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)