Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk or a combination of commands to read and calculate nth lines from pattern
Top Forums Shell Programming and Scripting awk or a combination of commands to read and calculate nth lines from pattern Post 303030229 by rdrtx1 on Thursday 7th of February 2019 09:13:40 AM
Old 02-07-2019
Start with:

Code:
awk '
1
! (NR % 4) {if (length($2)) type=$2;}
! (NR % 12) || ! ((NR + 4) % 12) {sum+=$1;}
! (NR % 12) {
   print "new-header";
   print "new-header - description";
   print "info-xyz";
   printf "%.2f %s\n", sum, type;
}
' data_file

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Combination Of commands

Hello All, I just wanted to know what are the different ways of using commands in combination. The most common one which i know is using pipes. Also grouping is also done like ( ls; date) where output of both the commands is displayed. Are there any other ways of combining various... (2 Replies)
Discussion started by: rahulrathod
2 Replies

2. UNIX for Dummies Questions & Answers

combination of two commands

I want to show a output like this Lee Ballancore PID TTY TIME CMD 31799 pts/3 00:00:00 vim 31866 pts/3 00:00:00 vim 2495 pts/7 00:00:00 vim 8368 pts/0 00:00:00 vim 9544 pts/2 00:00:00 ps Alistairr Rutherford PID TTY TIME CMD 8368 pts/0 00:00:00 vim 9544 pts/2 00:00:00 ps ... (3 Replies)
Discussion started by: nehaquick
3 Replies

3. Shell Programming and Scripting

Advice using cut & echo combination commands

Hi, I am cutting data from a fixed length test file and then writing out a new record using the echo command, the problem I have is how to stop multiple spaces from being written to the output file as a single space. Example: cat filea | while read line do field1=`echo $line | cut -c1-2` ... (6 Replies)
Discussion started by: dc18
6 Replies

4. Shell Programming and Scripting

read lines between search pattern

I have a file split something like 01/11/2010: No of users 100 02/11/2010: No of users 102 03/11/2010: No of users 99 ... I want to search the file for a particular date and then extract the following line with the date, something like 02/11/2010 No of users 102 I can grep... (6 Replies)
Discussion started by: gefa
6 Replies

5. Shell Programming and Scripting

search pattern and read lines

Hi, I have a huge de-limited file which has pattern : 99"9876"2010-11-21 12:51:01"J"MNOPQRS ID# 2-1234-1234-0099-9876-0 "" <<read>> 99"9876"2010-11-21 12:51:01"K"R-EMP# 01234567 (LOGOFF) "" <<read>> 99"9876"2010-11-21 12:51:01"L" *AUTO LOGOFF* ... (3 Replies)
Discussion started by: angie1234
3 Replies

6. Shell Programming and Scripting

Using AWK to find top Nth values in Nth column

I have an awk script to find the maximum value of the 2nd column of a 2 column datafile, but I need to find the top 5 maximum values of the 2nd column. Here is the script that works for the maximum value. awk 'BEGIN { subjectmax=$1 ; max=0} $2 >= max {subjectmax=$1 ; max=$2} END {print... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

7. Shell Programming and Scripting

Insert new pattern in newline after the nth occurrence of a line pattern - Bash in Ubuntu 12.04

Hi, I am getting crazy after days on looking at it: Bash in Ubuntu 12.04.1 I want to do this: pattern="system /path1/file1 file1" new_pattern=" data /path2/file2 file2" file to edit: data.db - I need to search in the file data.db for the nth occurrence of pattern - pattern must... (14 Replies)
Discussion started by: Phil3759
14 Replies

8. Shell Programming and Scripting

Help with parsing file with combination of pattern

I have a file1 like prt1|als28.1 prt3|als53.1 prt2|als550.1 prt1|bls9.2 prt2|als7.2 prt2|bls0.2 prt2|als872.1 prt1|bls871.1 prt2|als6.2 prt4|als22.1 prt2|bls43.2 I want to create a file2 from this file by comparing all the possible combinations of patterns (prt) assuming prt1... (3 Replies)
Discussion started by: sammy777
3 Replies

9. Shell Programming and Scripting

Optimize a combination of commands

Im currently running this command to satisfy a particular task. it works for my purposes. but i want to be able to optimize this string of commands and have it be reduced to 1 or 2 commands, if at all possible: head -4 datafile 2>/dev/null | cut -c1-400 | wc | awk '{print $2$1$3}' (5 Replies)
Discussion started by: SkySmart
5 Replies

10. UNIX for Beginners Questions & Answers

awk to remove pattern and lines above pattern

In the awk below I am trying to remove all lines above and including the pattern Test or Test2. Each block is seperated by a newline and Test2 also appears in the lines to keep but it will always have additional text after it. The Test to remove will not. The awk executed until the || was added... (2 Replies)
Discussion started by: cmccabe
2 Replies

LEARN ABOUT REDHAT

sum

sum(n)									sum								    sum(n)

NAME

       sum - calculate a sum(1) compatible checksum

SYNOPSIS

       package require Tcl 8.2

       package require sum ?1.0?

       ::crc::sum ?-format format? message

       ::crc::sum ?-format format? -filename file

DESCRIPTION

       This  package  provides	a Tcl-only implementation of the sum(1) command which calculates a 16 bit checksum value from the input data.  The
       BSD sum algorithm is used by default but the SysV algorithm is also available.

COMMANDS

       ::crc::sum ?-format format? message

       ::crc::sum ?-format format? -filename file
	      The command takes string data or a file name and returns a checksum value calculated using the sum(1) algorithm. The result is  for-
	      matted using the format(n) specifier provided or as an unsigned integer (%u) by default.

OPTIONS

       -filename name
	      Return a checksum for the file contents instead of for parameter data.

       -format string
	      Return the checksum using an alternative format template.

EXAMPLES

       % crc::sum "Hello, World!"
       37287

       % crc::sum -format 0x%X "Hello, World!"
       0x91A7

       % crc::sum -file sum.tcl
       13392

SEE ALSO

       sum(1), cksum(n), crc32(n)

AUTHORS

       Pat Thoyts

KEYWORDS

       sum, cksum, checksum, crc, crc32, cyclic redundancy check, data integrity, security

crc									1.0								    sum(n)
All times are GMT -4. The time now is 04:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy