Capturing Particular Data

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Capturing Particular Data
# 1  
Old 03-20-2009
Error Capturing Particular Data

Hi everyone!

Can any one help me out regarding capturing relevant data from a file.

For e.g, if i want to capture the comment written after "Prompt:" for a particular date, like for this case what would be the command to capture the tag written after "Prompt:" for Date: 2009-03-20.

A brief intro is for your reference:

Actually i want to capture number of Prompt with their tags for one particular day using script, if any one can help me out in letting me know the command i can use that in my script later.

This script will run on daily basis and will capture the tags written after "Prompt:" for one particular date.

=============Date: 2009-03-18=============
[01:48:01][DS1] Prompt: Local network interface[] is opened.
[01:48:08][DS1] Prompt: Reading scu system config file successfully.
[01:48:08][DS1] Prompt: NrOfRCOMM 34-->35 of Item[RCOMM] in scusys.cfg changed.
[01:48:08][DS1] Prompt: Item[RCOMM] of scusys.cfg changed, Added as follow:
RCOMM_FE_ID[34] = 65
RCOMM_Version[34] = 1
RCOMM_OperationID[34] = 1120
RCOMM_UniqueOperationID[34] = 1120
RCOMM_ServiceKey[34] = 1001
RCOMM_ControlFlag[34] = 0
RCOMM_ExecuteFE[34] = 0
[01:48:08][DS1] Prompt: Refresh AS config file over, number of success: 2, number of failure: 0.
[01:48:08][DS1] Prompt: Local network interface[] is opened.
[01:48:08][DS1] Prompt: Detect a connection request from SAU(ip=
[01:48:08][DS1] Prompt: Detect a connection request from No.0 memory board.
[05:29:13][DS1] Prompt: Refresh AS config file over.
=============Date: 2009-03-19=============
[02:20:02][DS1] Prompt: Local network interface[] is opened.
[05:00:03][DS1] Prompt: Local network interface[] is opened.
=============Date: 2009-03-20=============
[02:20:02][DS1] Prompt: Local network interface[] is opened.
[05:00:04][DS1] Prompt: Local network interface[] is opened.
# 2  
Old 03-20-2009
You can use sed to do that it will start looking at lines starting with "<beginingOfLine>=<anyNumberOfTimes>Date: <date>" until it reaches another line begining with =<anyNumberOfTimes>, then remove all the text up to and including the word "Prompt:"
sed -n -e '/^=*Date: 2009-03-18/,/^=*/s/^.* Prompt: //p' inputFile

# 3  
Old 03-20-2009
Thanks ldapswandog,

Things started to workout, but the output is as follows by using your command;

Local network interface[] is opened. (i.e. the starting line for that date)

and if i change ur command to :

sed -e '/^=*Date: 2009-03-18/,/^=*/s/^.* Prompt: //p' inputFile

then the oputput is same as input file

please guide.
# 4  
Old 03-20-2009
Try awk:
awk -F:\  'f && /Prompt/{print $2}/=$/{f=((/2009-03-20/)?1:0)}' log

Last edited by danmero; 03-20-2009 at 10:01 PM..
# 5  
Old 03-21-2009
Sorry about that you need to add an '=' sign to each of the wildcard searches so it consistently captures lines with 2 or more in a row.
sed -n -e '/^==*Date: 2009-03-18/,/^==*/s/^.* Prompt: //p' inputFile

# 6  
Old 03-21-2009
thnks a million for this

it really worked

also please help me from this prespective that

now by running the mentioned commnad the output is without time, how can i get the time.
# 7  
Old 03-22-2009
Start the substitute at [DS1]
sed -n -e '/^==*Date: 2009-03-18/,/^==*/s/\[DS1\].* Prompt: / /p' inputFile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Perl : not capturing all the data from excel sheet

Hi folks, I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month. If it matches current date and month then the matched records are printed as... (1 Reply)
Discussion started by: giridhar276
1 Replies

2. Shell Programming and Scripting

capturing selective data from a vcd file

Hi, This is a vcd file.A vcd file may have 'n' modules. 1) I need to capture the data in bold,i.e. the module names (shown in bold) 2) Also i need to capture the data inside each individual module,say for tst_bench_top ,i need to capture data from line 4 to line 20 ... I just want one... (2 Replies)
Discussion started by: veerabahu
2 Replies

3. Red Hat

capturing data of nethogs

I have installed nethogs to see which process is sending load on the network. i would like to know how can i capture its data in a log file. Or is there is a unix command like script or tee which can help me to capture the data using cronjob (0 Replies)
Discussion started by: anshus1
0 Replies

4. IP Networking

How to capturing packet data so i can see the Version, IHL, TOS, etc?

Helo Folks :) i had read an answer in this thread unixcom/programming/117551-calculate-ip-header-checksum-manually.html i need to know what the software name that was used to capturing packet data in a network, just like the packet's capture output that showed up in the thread. Thank you :)... (5 Replies)
Discussion started by: polutan
5 Replies

5. Shell Programming and Scripting

Capturing data between patterns

Hii, Friends, I want your help in one of my problem. My problem is as follows. I have a flat file as follows (Just a sample) MHT011 01(DOT)8750707asdfas8609 03(DOT)ASD3453ASD 09(DOT)876JHT87 11(DOT)sfd324ert TTT077 01(MOB)876786klj897 06(MOB)876JHT87 07(MOB)sfd324ert... (4 Replies)
Discussion started by: anushree.a
4 Replies

6. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

7. Shell Programming and Scripting

Capturing Data between first quote and next quote

I have input file like RDBMS FALIURE UTY8703 'USER_WORK.TEST' .HIghest return code '12' I want to parse data which comed between first quote till next quote USER_WORK.TEST can you please suggest how to do that (4 Replies)
Discussion started by: scorp_rahul23
4 Replies

8. Shell Programming and Scripting

Capturing Unix Traceroute data

Hi guys, I need a way to capture the host on the next-to-last hop in a traceroute output. The last output is the destination but I need to capture the router just before the last hop. I can do this in perl but I'm not so sure about Shell... I'm on AIX 5.3 using ksh any ideas? ... (3 Replies)
Discussion started by: TivoliGUY
3 Replies

9. UNIX for Dummies Questions & Answers

Capturing some data from a file into a variable

I have a file with some values in a tab delimted format Eg: 'test' contains: a<tab>b<tab>c<tab>Trk_12345678 now i need to capture this value 'Trk_12345678' into a variable say 'x' and append that value of 12345678 to 12345679 and store is back to a new 'test1' file as : 'test1'... (11 Replies)
Discussion started by: shiroh_1982
11 Replies

10. Shell Programming and Scripting

capturing process id

I am newbie to unix shells world. I am trying to capture a background process id into a file so that it can be killed later. this process is basically a java program running in background as: java TestApp & this returning process id immediately. So how can i redirect that pid into a file.... (1 Reply)
Discussion started by: bvreddy
1 Replies
Login or Register to Ask a Question

Featured Tech Videos