Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Using Awk to Search Two Strings on One Line

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Using Awk to Search Two Strings on One Line
# 1  
Old 08-16-2010
Using Awk to Search Two Strings on One Line
If i wanted to search for two strings that are on lines in the log, how do I do it?

The following code searches for just one string that is one one line.


Code:
awk '/^[0-9][0-9]/ {split($2,s,",");a=$1 FS s[1]} /failure agaf@fafa/ {b=a} END{print b}' urfile

What if I wanted to search for "failure agaf@fafa" AND "user"? How do i do that?

meaning, i want to see all lines in the file "urfile" that contains the strings "failure agaf@fafa" AND "user" on the same lines.

thanks guys
# 2  
Old 08-16-2010
Code:
awk '/^[0-9][0-9]/ {split($2,s,",");a=$1 FS s[1]} /failure agaf@fafa/ && /user/ {b=a} END{print b}' urfile

# 3  
Old 08-17-2010
Seems your code only gives the last record. Here are some updates that you can get all records, if this is your expect.

Code:
awk -F, '/^[0-9][0-9]/ && /failure agaf@fafa/ && /user/ {print $1}' urfile

# 4  
Old 08-17-2010
Quote:
Originally Posted by anbu23
Code:
awk '/^[0-9][0-9]/ {split($2,s,",");a=$1 FS s[1]} /failure agaf@fafa/ && /user/ {b=a} END{print b}' urfile



this one seems to be what I need. i need the very last record. but when i run the following command, which is in a script, i get the following output:

Code:
awk "/^[0-9][0-9]/ {split($2,s,",");a=$1 FS s[1]} /$STRING1/ && /$STRING2/ {b=a} END{print b}" $LOGFILE

Output:

awk: /^[0-9][0-9]/ {split(5,s,,);a=/prod/text.log FS s[1]} /java.lang.Thread.run/ && /Threa/ {b=a} END{print b}
awk:                          ^ syntax error
awk: /^[0-9][0-9]/ {split(5,s,,);a=/prod/text.log FS s[1]} /java.lang.Thread.run/ && /Threa/ {b=a} END{print b}
awk:                           ^ syntax error
awk: fatal: 0 is invalid as number of arguments for split

I don't know how to debug this.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Use strings from nth field from one file to match strings in entire line in another file, awk

I cannot seem to get what should be a simple awk one-liner to work correctly and cannot figure out why. I would like to use patterns from a specific field in one file as regex to search for matching strings in the entire line ($0) of another file. I would like to output the lines of File2 which... (1 Reply)
Discussion started by: jvoot
1 Replies

2. Shell Programming and Scripting

awk strings search + print next column after match

Hi, I have a file filled with search strings which have a blank in between and look like this: S. g. Ehr. o. Jg. v. d. Chijs g. Ehr. Now i would like to search for the strings and it also shall return the next column after the match. awk -v FILE="search_strings.txt" 'BEGIN {... (10 Replies)
Discussion started by: sdf
10 Replies

3. Shell Programming and Scripting

awk to search similar strings and add their values

Hi, I have a text file with the following content: monday,20 tuesday,10 wednesday,29 monday,10 friday,12 wednesday,14 monday,15 thursday,34 i want the following output: monday,45 tuesday,10 wednesday,43 friday,12 (3 Replies)
Discussion started by: prashu_g
3 Replies

4. Shell Programming and Scripting

awk search an output string between two strings

I would like to search for strings stored in searchstringfile.txt in inputfiles. searchstringfile.txt J./F. Gls. Wal F. Towerinput1.txt What is needed is J./F. 12 var Gls. Wal 16 interp. Tower 12 input2.txt Awk shall search for F. 16 pt. J./F. 22 output.txt input1.txt J./F. = 12 var... (3 Replies)
Discussion started by: sdf
3 Replies

5. Shell Programming and Scripting

awk search strings from array in textfile

I am wanting to take a list of strings and loop through a list of textfiles to find matches. Preferably with awk and parsing the search strings into an array. // Search_strings.txt tag string dummy stuff things // List of files to search in textfile1.txt textfile2.txt The... (6 Replies)
Discussion started by: sdf
6 Replies

6. Shell Programming and Scripting

Search for a multi-line strings in a file

Hello I need to search for a mult-line strngs(with spaces in between and qoted) in a file1 and replace that text with Fixed string globally in file1. The strng to search for is in file2. The file is big with some 20K records. so speed and effciency is required file1: (where srch & rplc will... (7 Replies)
Discussion started by: Hiano
7 Replies

7. Shell Programming and Scripting

awk how to search strings within a file from two different lines

Hi, i would really appreciate any help anyone can give with the following info. Thanks in advance. I need to run a search on a file that contains thousands of trades, each trade is added into the file in blocks of 25 lines. i know the search has to take place between a time stamp specified... (4 Replies)
Discussion started by: sp3arsy
4 Replies

8. Shell Programming and Scripting

Awk search for a element in the list of strings

Hi, how do I match a particular element in a list and replace it with blank? awk 'sub///' $FILE list="AL, AK, AZ, AR, CA, CO, CT, DE, FL, GA, HI, ID, IL, IN, IA, KS, KY, LA, ME, MD, MA, MI, MN, MS, MO, MT, NE, NV, NH, NJ, NM, NY, NC, ND, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VT, VA, WA,... (2 Replies)
Discussion started by: grossgermany
2 Replies

9. Shell Programming and Scripting

Varying number of awk search strings

I've created an awk script that handles a varying number of search strings handed to it as command line parameters ($1 $2 etc). There may be 1, or 2 or 3 or more. A simplified version of the script is: awk -v TYP="$1 $2 $3 $4 $5 $6" ' BEGIN { CTYP = split (TYP,TYPP," ") } ... (2 Replies)
Discussion started by: CarlosNC
2 Replies

10. Shell Programming and Scripting

awk search for Quoted strings (')

Hi All, I have files: 1. abc.sql 'This is a sample file for testing' This does not have quotations this also does not have quotations. and this 'has quotations'. here I need to list the hard coded strings 'This is a sample file for testing' and 'has quotations'. So i have... (13 Replies)
Discussion started by: kprattip
13 Replies
Login or Register to Ask a Question