Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

grep or awk or sed not sure which to use here

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting grep or awk or sed not sure which to use here
# 1  
Old 02-26-2009
grep or awk or sed not sure which to use here
Hi All,

I have a huge file, I need to two things from this file. I need to know the IP address or the hostname and second thing is the date&time.

The file looks like this and I need to get my data from this...

Trying...
Connected to 204.109.172.117.
Escape character is '^]'.
Fri Oct 31 16:32:49 2008
Connection closed.
Trying...
Connected to meph1.xrb.com
Escape character is '^]'.
Fri Oct 31 13:38:31 2008
Connection closed.
Trying...
Connected to xrbcp1.xrb.com
Escape character is '^]'.
Thu Feb 26 11:23:27 2009
Connection closed.
Trying...
Connected to xrbcp2.xrb.com.
Escape character is '^]'.
Thu Feb 26 11:23:40 2009
Connection closed.
Trying...
Connected to 204.109.172.118.
Escape character is '^]'.
Fri Oct 31 16:32:49 2008
Connection closed.


I did grep -E and it's sort of working but not there 100%.

cat dst_result_02261123.txt |grep -E "Connected|Thu"

If I run the file on Friday or any other day, I have to change this grep -E value. I was wondering is there better way to do in awk or sed?


Thanks.
# 2  
Old 02-26-2009
Code:
day=$( date +%a )
grep -e "$day" -e "Connected" dst_result_02261123.txt

# 3  
Old 02-26-2009
Quote:
Originally Posted by samnyc
I did grep -E and it's sort of working but not there 100%.
What does "sort of working" mean? What does it do, and how does that differ from what you want?
Quote:

cat dst_result_02261123.txt |grep -E "Connected|Thu"

If I run the file on Friday or any other day, I have to change this grep -E value. I was wondering is there better way to do in awk or sed?
Code:
day=$1 ## specify day on the command line
grep -E "Connected|$day" dst_result_02261123.txt

# 4  
Old 02-26-2009
I want to add blank line after each result. I have no idea what to command to use there.

Here is my result from grep -e

Connected to xrbarb1.xrb.quotron.com.
Thu Feb 26 11:23:26 2009
Connected to xrbarb2.xrb.quotron.com.
Thu Feb 26 11:23:26 2009
Connected to xrbcp1.xrb.quotron.com.


so I want the result to look like this.... Please let me know if I need to use sed or awk to do this?


Connected to xrbarb1.xrb.quotron.com.
Thu Feb 26 11:23:26 2009

Connected to xrbarb2.xrb.quotron.com.
Thu Feb 26 11:23:26 2009

Connected to xrbcp1.xrb.quotron.com.
Thu Feb 26 11:23:26 2009


Thanks again for your help.
# 5  
Old 02-26-2009
Quote:
Originally Posted by samnyc
I want to add blank line after each result. I have no idea what to command to use there.

Here is my result from grep -e

Connected to xrbarb1.xrb.quotron.com.
Thu Feb 26 11:23:26 2009
Connected to xrbarb2.xrb.quotron.com.
Thu Feb 26 11:23:26 2009
Connected to xrbcp1.xrb.quotron.com.


so I want the result to look like this.... Please let me know if I need to use sed or awk to do this?


Connected to xrbarb1.xrb.quotron.com.
Thu Feb 26 11:23:26 2009

Connected to xrbarb2.xrb.quotron.com.
Thu Feb 26 11:23:26 2009

Connected to xrbcp1.xrb.quotron.com.
Thu Feb 26 11:23:26 2009
Code:
day=$1
awk -v day=$day '/Connected/
$0 ~ day { print; print "" }' dst_result_02261123.txt

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Grep/awk/sed help

got a file as y.txt 1 abc,def,ghj 2 defj,abc.kdm,ijk 3 lmn,cbk,mno 4 tmp,tmop,abc,pkl 5 pri,chk,cbk,lmo 6 def,cbk.pro,abc.kdm i want to search in the above file the key word like abc looking for two outcomes by passing the parameter value as abc into function and the two outocmes are... (6 Replies)
Discussion started by: silgun
6 Replies

2. Shell Programming and Scripting

grep? awk? sed? I don't know

Hi everyone! I have a file like this And I would like to find the Medium label when the value "last write" is "Jan 14" (it's could be another value like "jan 6") I really don't know what way to use to solve this problem... Thanks! (5 Replies)
Discussion started by: Castelior
5 Replies

3. UNIX for Dummies Questions & Answers

grep/awk/sed?

Thread1 { x = 2 y = 10485 } Thread2 { x = 16 y = 1048 } Thread3 { x = 1 y = 1049 } Thread4 { x = 4 y = 1047 z = 500 } Suppose the above is a piece of code. I need to automate and verify that the value of x under Thread1's 2. There are several... (3 Replies)
Discussion started by: foxtron
3 Replies

4. Shell Programming and Scripting

help using sed/awk/grep

thanks for your reply. but i'm not quite sure what your code is doing. i may be using it wrong but i'm not getting what i'm supposed to get. could you please elaborate? thanks again, (6 Replies)
Discussion started by: kratos.
6 Replies

5. UNIX for Dummies Questions & Answers

awk grep sed or something better

Hello all, Can anyone help with the following? :) I have file1 with 150,000 words in a list and file2 with 148,000 words in a list - all of which are in file1. I want to create a new file with the words that DO NOT match (i.e of 2000 words). I have done this very simple command , which is... (1 Reply)
Discussion started by: dr_sabz
1 Replies

6. UNIX for Dummies Questions & Answers

How could i get this by sed or grep or awk ????

------------------------------------------------------------------ Ex of Warning messgae,(Many similar lines occure for Both Test and Test1) -WARNING:Below Field not implemented in file File name: /home/test/ new/file1, msg buffer is: :Test:000948 ... (1 Reply)
Discussion started by: prsam
1 Replies

7. UNIX for Dummies Questions & Answers

Grep Sed or Awk?

I have two .txt files one called good.txt and the other one is called bad.txt. Both contain email addresses in the following format: john@john.com bob@bob.com sarah@sarah.com Basically, I want to scrub good.txt against bad.txt and save the resulting output in scrubbed.txt meaning that if... (2 Replies)
Discussion started by: holyearth
2 Replies

8. UNIX for Dummies Questions & Answers

Awk, Sed and Grep

Hello. I am an older newbie trying to learn Unix. I have a task to perform and it entails counting lines of code. Currently, I am pointing to the directory where the files are contained and performing a 'find' on the file extensions (cpp, c, html, java, etc.) and piping that info with a 'wc -l'.... (2 Replies)
Discussion started by: mastachef
2 Replies

9. Shell Programming and Scripting

Sed | Awk | Grep

Can someone help me in understanding when to use SED, AWK and GREP (3 Replies)
Discussion started by: kn.naresh
3 Replies

10. Shell Programming and Scripting

need help!!!awk,grep,sed

hi all by using cat /etc/passwd I've got these output. ajh1ect:x:839:501:Anthony:/home/ajh1ect:/bin/bash mjb1ect:x:840:501:Michael:/home/mjb1ect:/bin/bash mv3ect:x:841:501:Marian:/home/mv3ect:/bin/bash now I want to see just the user ID and group ID. so what is the code will be with... (2 Replies)
Discussion started by: nokia1100
2 Replies
Login or Register to Ask a Question