Sponsored Content
Top Forums Shell Programming and Scripting Process a file for line count using for loop in awk Post 302949035 by rossi on Monday 6th of July 2015 09:59:01 AM
Old 07-06-2015
Process a file for line count using for loop in awk

Hi,

I have a file with contents

Quote:
Name = abc
HPScore = 6.00
HMScore = 7.99
HSScore = 7.73
Pre avg = 2.90
Pre bind ene =1.09
Name = djhf
HPScore = 16.00
HMScore = 17.99
HSScore = 17.73
Pre avg = 21.90
Pre bind ene =111.09
Name = sgs
HPScore = 12.00
HMScore = 43.99
HSScore = 72.73
Pre avg = 25.90
Pre bind ene =14.09
Name = lksf
HPScore = 61.00
HMScore = 34.99
HSScore = 1.73
Pre avg = 34.90
Pre bind ene =12.0
.
.
.
.
So what I have to do is
Quote:
Name = abc HPScore = 6.00 HMScore = 7.99 HSScore = 7.73 Pre avg = 2.90 Pre bind ene =1.09
Name = djhf HPScore = 16.00 HMScore = 17.99 HSScore = 17.73 Pre avg = 21.90 Pre bind ene =111.09
. . . . .
. . . . .
In short, break the file after every 6 lines and then truncate new line to tab for these 6 lines.
I am not able to execute the for loop in awk properly.
The idea is something like this:
less file| awk '{for .... {if ((nr>=1) && (nr<=6)) print $0}}'| tr "\n" "\t"

Can someone help me on this
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get the line count from 2nd line of the file ?

Hi, I want to get the line count of the file from the 2nd line of the file ? The first line is header so want to skip that. Thanks. (8 Replies)
Discussion started by: smc3
8 Replies

2. Shell Programming and Scripting

awk: sort lines by count of a character or string in a line

I want to sort lines by how many times a string occurs in each line (the most times first). I know how to do this in two passes (add a count field in the first pass then sort on it in the second pass). However, can it be done more optimally with a single AWK command? My AWK has improved... (11 Replies)
Discussion started by: Michael Stora
11 Replies

3. Shell Programming and Scripting

Read file line by line and process the line to generate another file

Hi, i have file which contains data as below(Only sample shown, it may contain more data similar to the one shown here) i need to read this file line by line and generate an output file like the one below i.e based on N value the number of MSISDNs will vary, if N=1 then the following... (14 Replies)
Discussion started by: aemunathan
14 Replies

4. Shell Programming and Scripting

Shell script to read a text file line by line & process it...

Hi , I am trying to write an shell, which reads a text file (from a location) having a list of numbers of strictly 5 digits only ex: 33144 Now my script will check : 1) that each entry is only 5 digits & numeric only, no alphabets, & its not empty. 2)then it executes a shell script called... (8 Replies)
Discussion started by: new_to_shell
8 Replies

5. Shell Programming and Scripting

IF awk in a while read line-loop

Hi As a newbe in scripting, i struggle hard with my first script. What i want to do is, bringing data of two files together. file1: .... 05/14/12-04:00:00 41253 4259 5135 5604 5812 5372 05/14/12-04:10:00 53408 5501 6592 7402 7354 6639 05/14/12-04:20:00 58748 6037 7292 8223... (13 Replies)
Discussion started by: IMPe
13 Replies

6. Shell Programming and Scripting

awk to count start and end keyword in a line

Hello fellow awkers and seders: need to figure out a way to ensure a software deployment has completed by checking its trace file in which I can store the deployment results as follows: echo $testvar ===== Summary - Deploy Result - Start ===== ===== Summary - Deploy Result - End =====... (1 Reply)
Discussion started by: ux4me
1 Replies

7. 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

8. Programming

awk to count occurrence of strings and loop for multiple columns

Hi all, If i would like to process a file input as below: col1 col2 col3 ...col100 1 A C E A ... 3 D E G A 5 T T A A 6 D C A G how can i perform a for loop to count the occurences of letters in each column? (just like uniq -c ) in every column. on top of that, i would also like... (8 Replies)
Discussion started by: iling14
8 Replies

9. Shell Programming and Scripting

Bash script to read a file from particular line till required line and process

Hi All, Am trying to write wrapper shell/bash script on a utility tool for which i need to pass 2 files as arugment to execute utility tool. Wraper script am trying is to do with above metion 2 files. utility tool accepts : a. userinfo file : which contains username b. item file : which... (2 Replies)
Discussion started by: Optimus81
2 Replies

10. UNIX for Dummies Questions & Answers

For loop in process each file

Hi I have following codecd /tmp/test/ for vfile in `ls -1` do for vlink in `ls -l /tmp/testfile/*|bin/grep "local/init\.d/$vfile$"|bin/awk -F"->" '{print($1)}'|bin/awk -F"/" '{print($NF)}'` I know `ls -1` list only file, but I don't... (3 Replies)
Discussion started by: stew
3 Replies
DPKG-PRECONFIGURE(8)						      Debconf						      DPKG-PRECONFIGURE(8)

NAME
dpkg-preconfigure - let packages ask questions prior to their installation SYNOPSIS
dpkg-preconfigure [options] package.deb dpkg-preconfigure --apt DESCRIPTION
dpkg-preconfigure lets packages ask questions before they are installed. It operates on a set of debian packages, and all packages that use debconf will have their config script run so they can examine the system and ask questions. OPTIONS
-ftype, --frontend=type Select the frontend to use. -pvalue, --priority=value Set the lowest priority of questions you are interested in. Any questions with a priority below the selected priority will be ignored and their default answers will be used. --terse Enables terse output mode. This affects only some frontends. --apt Run in apt mode. It will expect to read a set of package filenames from stdin, rather than getting them as parameters. Typically this is used to make apt run dpkg-preconfigure on all packages before they are installed. To do this, add something like this to /etc/apt/apt.conf: // Pre-configure all packages before // they are installed. DPkg::Pre-Install-Pkgs { "dpkg-preconfigure --apt --priority=low"; }; -h, --help Display usage help. SEE ALSO
debconf(7) AUTHOR
Joey Hess <joeyh@debian.org> 2018-02-28 DPKG-PRECONFIGURE(8)
All times are GMT -4. The time now is 11:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy