Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help Need to fetch the required data

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help Need to fetch the required data
# 1  
Old 09-16-2013
Help Need to fetch the required data
Hi Guys,

Am in need of your help one more time on my real data.
I have a file which contains more than thousand lines of data

Live data shown for 4 iterations. We have more than thousand lines of data:-
--------------------------------------------------------------------------

Code:
COM.ISEXTDC.PKGINIT:INIT
N
2013-09-12
12:54:45
1
cHitLast
APPS_MANAGEMENT
N
2013-09-12
21:14:19
18
cHitLast
APPS_MANAGEMENT:CLEARCLIENTQUEUE
N
2013-09-12
21:24:57
18
cHitLast
APPS_MANAGEMENT.CLEANUP:CLIENT
N
2013-09-12
20:14:18
3
cHitLast

--------------------------------
1) Need to check for every 6th line ( 'cHitLast') contains a value and it is greater than zero (o)
I dont want to print anything if the sixth line is other than numeric.
2) If the value is greater than 0 then need to print above 5 lines including the 6th line in the tabular format

Example:-
Code:
APPS_MANAGEMENT.CLEANUP:CLIENT
N
2013-09-12
20:14:18
3
5   ----> Here i have changed it to value 5 then the output should be as below:- 
 
Name       Prefetched       AccessLast               AccessTotal  Running
APPS...     N              2013-09-12 20:14:18           3              5

Thanks for your support in advance.
# 2  
Old 09-16-2013
Code:
awk 'NR%6 {a=a"\t"$0;} NR%6==0 && $0+0>0 {a=a"\t"$0;sub(/\t/,"",a);print a;a=""} NR%6==0 {a=""}' file
APPS_MANAGEMENT.CLEANUP:CLIENT  N       2013-09-12      20:14:18        3       5

# 3  
Old 09-16-2013
Hi Jotne,

Thanks for your response.
I am receiving the below error when I have executed the given code and nothing is getting logged in the log file.

awk: syntax error near line 1
awk: bailing out near line 1


awk 'NR%6 {a=a"\t"$0;} NR%6==0 && $0+0>0 {a=a"\t"$0;sub(/\t/,"",a);print a;a=""} NR%6==0 {a=""}'< $TEMP/memstat.out3 >> $TEMP/$SCRIPT.log
# 4  
Old 09-16-2013
Try to run it manually from bash, not in script to see error.
Code:
awk 'NR%6 {a=a"\t"$0;} NR%6==0 && $0+0>0 {a=a"\t"$0;sub(/\t/,"",a);print a;a=""} NR%6==0 {a=""}' $TEMP/memstat.out3

Shorten some:
Code:
awk 'NR%6 {a=a?a"\t"$0:$0} NR%6==0 {if ($0+0) {a=a"\t"$0;print a}a=x}'  $TEMP/memstat.out3

Last edited by Jotne; 09-16-2013 at 09:57 AM..
# 5  
Old 09-16-2013
If you are on solaris, use nawk

--ahamed
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Fetch data from file

Hi, I am new to scripting. I have a log file and need to fetch specific logs and copy to another file. A copy of the log is like this: =============================================================== = JOB : server123#jobs1.jobstream1 = USER : andyc = Tue 08/01/17... (3 Replies)
Discussion started by: Prngp
3 Replies

2. UNIX for Beginners Questions & Answers

How to fetch specific data from a file.?

Hi , I have a file which contains 2 days logs(here it is 24 and 25) I want to list data only for date 25 fron the file. please suggest me how should i get this. file content mentioned below 17-05-24 Name Succ Fail 00:00:29 ... (5 Replies)
Discussion started by: scriptor
5 Replies

3. Shell Programming and Scripting

Need to fetch only selected data in CSV

Hi Team, I m getting my script commands output like given below GETA-TILL-INF; U-UU-YRYT-NOD-6002 2015-05-14 THU 19:44:10 C2221 RETRIEVE TILL INFORMATION : COMPLD ---------------------------------------------------------------------- CONNECT_CARD_ID ... (9 Replies)
Discussion started by: Ganesh Mankar
9 Replies

4. UNIX for Dummies Questions & Answers

how to fetch data in unix

Hi All, I have a file with the below data as shown. A|2|20120430 B|EMP|NAME|DEPT C|12|SARC|01 C|23||ASDD|02 D|END OF FILE I want to fetch only the records that contains C|, what is unix command to fetch this data. Thanks (5 Replies)
Discussion started by: halpavan2
5 Replies

5. Shell Programming and Scripting

Fetch data between two dates from a file

Hi All, I m new to this forum & UNix too. currently i have a requirement which can fetch data from a logfile between two dates or timestamp. for example: 1. data from 2012 Jun to 2012 Jul 2. data from 2012 Jun to 2012 Jul 07 3. data from 2012 Jun 16 10:20 to 2012 Jul 03 10:10 Please... (7 Replies)
Discussion started by: KDMishra
7 Replies

6. Shell Programming and Scripting

Fetch data from a particular location

I want to fetch value from a particular location from a file but in each line in the file it appears at a different position so i tried using variable with cut command but it is not working properly. The code i have written is #!/bin/sh cat Sri1.log | while read d2 do grep -w... (9 Replies)
Discussion started by: Prachi Gupta
9 Replies

7. Shell Programming and Scripting

How to fetch data between two timestamps in a file using KSH

Hi, I got a requirement to fetch data between two time stamps in a big log file and grep for a word in that particular time interval of data. Here is my log looks like: 2012/04/08-14:35:56 Abcdefg 2012/04/08-14:35:56 Hijklmnophhoishfw 2012/04/08-14:35:56... (1 Reply)
Discussion started by: siri_886
1 Replies

8. Shell Programming and Scripting

fetch data between two timestamp using script

Hi Guys, I have the data in below format. 25 Dec 2011 03:00:01 : aaaaaaaaaaaaaaa 25 Dec 2011 04:23:23 : bbbbbbbbbbbbbbb 25 Dec 2011 16:12:45 : ccccccccccccccc 26 Dec 2011 04:45:34 : ddddddddddddddd 26 Dec 2011 17:01:22 : eeeeeeeeeeeeeee 27 Dec 2011 12:33:45 : ffffffffffffffffffffffff 28... (13 Replies)
Discussion started by: jaituteja
13 Replies

9. Shell Programming and Scripting

Script to fetch data from HTML

Hi All, There is a link from were I usually search somthing and fetch the data from. Is there any way to automate it through a script if I mention search criteria in a note pad. I mean the script to search the content on the notepad and resutls should be placed into another file. ... (2 Replies)
Discussion started by: indradev
2 Replies

10. Shell Programming and Scripting

Fetch selected data from webpage

Hi All, Can anybody tell me the command used for extracting some selected lines from a web-page. I guess we'll have to do this using wget or Curl to achieve this.... If anbody has any idea abt it, kindly post your reply ASAP. Thanks. (1 Reply)
Discussion started by: sunnydynamic15
1 Replies
Login or Register to Ask a Question