Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Reading next line

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Reading next line
# 1  
Old 05-18-2011
Reading next line
Hello guys,

Need some help below is my input file..
Code:
01:00
LK1           188345376       277847504       466192880
LK2           163245288       12267736        175513024
LK3           187179016       12497064        199676080
LK4           437091632       12165056        449256688

01:30
LK1           320761096       9688392         330449488
LK2           122604024       9736984         132341008
LK3           139040616       9732480         148773096
LK4           320140304       9873376         330013680

02:00
LK1           102197584       151641096       253838680
LK2           88678952        7528176         96207128
LK3           101039816       7336624         108376440
LK4           233832416       7318776         241151192

02:30
LK1           74294496        110946152       185240648
LK2           65194416        5827472         71021888
LK3           74233104        5818168         80051272
LK4           170249240       5666504         175915744

The input file is generated half hourly into this file, as above. What i have to now is, for each hour, i have to take the data in the 3rd column.

e.g
Code:
@02:30,

below shud be my data.
Code:
0230
LK1           110946152       
LK2           5827472         
LK3           5818168         
LK4           5666504

I'd prefer to use shell script.
thanks

Moderator's Comments:
Mod Comment Please use [code] and [/code] tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks.
Last edited by zaxxon; 05-18-2011 at 08:55 AM.. Reason: code tags
# 2  
Old 05-18-2011
Code:
awk 'NF>3{print $1,$3 ;next}1' infile

use nawk or /usr/xpg4/bin/awk if on SunOS/Solaris plateform
# 3  
Old 05-18-2011
how will it break this to half hourly data with this command

---------- Post updated at 06:18 PM ---------- Previous update was at 06:13 PM ----------

ok ok i got it... it works with nawk...

but can u pls explain the what does the NF>3{print $1,$3 ;next}1' means..

---------- Post updated at 06:22 PM ---------- Previous update was at 06:18 PM ----------

ok now with this input

Code:
00:00
LK1 17324424
LK2 17236608
LK3 17655088
LK4 17427512

I need to perform a division of 1800 to get the results,

the output should print as below
e.g
Code:
00:00
LK1 <the results of 17324424/1800>

Moderator's Comments:
Mod Comment Please use [code] and [/code] tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks.
Last edited by zaxxon; 05-18-2011 at 08:56 AM.. Reason: code tags
# 4  
Old 05-18-2011
Code:
awk 'NF>3{print $1,$3/1800 ;next}1' infile

NF>3if number of fiels is greater than 3 (in fact actually i could have written NF>2 since it would mean that the third field exists)
{print $1,$3/1800;then print the first field and the third field divided by 1800
next} do not execute the reste of the command line and go reprocess the awk command from the beginning (NF>3)
1 means "true" which actually defaulty output the line that is currently read ($0)
Last edited by ctsgnb; 05-18-2011 at 07:36 AM..
# 5  
Old 05-18-2011
u r a genius man...

but can pls explain whats the line actually means?
Code:
 'NF>3{print $1,$3/1800 ;next}1'

Moderator's Comments:
Mod Comment Please use [code] and [/code] tags when posting code, data or logs etc. to preserve formatting and enhance readability, thanks.
Last edited by zaxxon; 05-18-2011 at 08:56 AM.. Reason: code tags
# 6  
Old 05-18-2011
I updated my previous post
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Reading a file line by line and print required lines based on pattern

Hi All, i want to write a shell script read below file line by line and want to exclude the lines which contains empty value for MOUNTPOINT field. i am using centos 7 Operating system. want to read below file. # cat /tmp/d5 NAME="/dev/sda" TYPE="disk" SIZE="60G" OWNER="root"... (4 Replies)
Discussion started by: balu1234
4 Replies

2. Shell Programming and Scripting

Replace values in script reading line by line using sed

Hi all, Let's say I have a script calling for the two variables PA_VALUE and PB_VALUE. for pa in PA_VALUE blah blah do for pb in PB_VALUE blah blah do I have a text file with two columns of values for PA and PB. 14.5 16.7 7.8 9.5 5.6 3.6 etc etc I would like to read this... (7 Replies)
Discussion started by: crimsonengineer
7 Replies

3. Shell Programming and Scripting

Reading line by line from live log file using while loop and considering only those lines start from

Hi, I want to read a live log file line by line and considering those line which start from time stamp; Below code I am using, which read line but throws an exception when comparing line that does not contain error code tail -F /logs/COMMON-ERROR.log | while read myline; do... (2 Replies)
Discussion started by: ketanraut
2 Replies

4. Shell Programming and Scripting

Comparison of fields then increment a counter reading line by line in a file

Hi, i have a scenario were i should compare a few fields from each line then increment a variable based on that. Example file 989878|8999|Y|0|Y|N|V 989878|8999|Y|0|N|N|V 989878|8999|Y|2344|Y|N|V i have 3 conditions to check and increment a variable on every line condition 1 if ( $3... (4 Replies)
Discussion started by: selvankj
4 Replies

5. Shell Programming and Scripting

Reading text file, comparing a value in a line, and placing only part of the line in a variable?

I need some help. I would like to read in a text file. Take a variable such as ROW-D-01, compare it to what's in one line in the text file such as PROD/VM/ROW-D-01 and only input PROD/VM into a variable without the /ROW-D-01. Is this possible? any help is appreciated. (2 Replies)
Discussion started by: xChristopher
2 Replies

6. Shell Programming and Scripting

How to start reading from the nth line till the last line of a file.

Hi, For my reuirement, I have to read a file from the 2nd line till the last line<EOF>. Say, I have a file as test.txt, which as a header record in the first line followed by records in rest of the lines. for i in `cat test.txt` { echo $i } While doing the above loop, I have read... (5 Replies)
Discussion started by: machomaddy
5 Replies

7. UNIX for Dummies Questions & Answers

Parsing file, reading each line to variable, evaluating date/time stamp of each line

So, the beginning of my script will cat & grep a file with the output directed to a new file. The data I have in this file needs to be parsed, read and evaluated. Basically, I need to identify the latest date/time stamp and then calculate whether or not it is within 15 minutes of the current... (1 Reply)
Discussion started by: hynesward
1 Replies

8. Shell Programming and Scripting

[Solved] Problem in reading a file line by line till it reaches a white line

So, I want to read line-by-line a text file with unknown number of files.... So: a=1 b=1 while ; do b=`sed -n '$ap' test` a=`expr $a + 1` $here do something with b etc done the problem is that sed does not seem to recognise the $a, even when trying sed -n ' $a p' So, I cannot read... (3 Replies)
Discussion started by: hakermania
3 Replies

9. Shell Programming and Scripting

Reading a file line by line and processing for each line

Hi, I am a beginner in shell scripting. I have written the following script, which is supposed to process the while loop for each line in the sid_home.txt file. But I'm getting the 'end of file' unexpected for the last line. The file sid_home.txt gets generated as expected, but the script... (6 Replies)
Discussion started by: sagarparadkar
6 Replies
Login or Register to Ask a Question