Sponsored Content
Top Forums Shell Programming and Scripting Help with awk command on report with headings Post 303024510 by cougartrace on Wednesday 10th of October 2018 08:46:49 AM
Old 10-10-2018
Help with awk command on report with headings

Hi all, I have a report that looks like this:

Code:
-------------------------------------------------
--                AOC - XXXXXXX                --
-------------------------------------------------

    Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
         1                  64069                 64069          0


-------------------------------------------------
--                AOC - XXXXXXXXX              --
-------------------------------------------------

    Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
         1                 259202                259202          0


-------------------------------------------------
--                AOC - XXXXXXXX               --
-------------------------------------------------

    Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
         1                  77523                 77523          0


If I only care about the Difference field (the last one). How do I use the awk command to skip the headings and just concencreate on the numerical lines of data?




Moderator's Comments:
Mod Comment Please use CODE tags as required by forum rules!

Last edited by RudiC; 10-10-2018 at 09:50 AM.. Reason: Added CODE tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help with awk to create report

Hi, I am trying to create a report using the following syntax: #!/bin/awk -f #script name: users_report BEGIN { FS=":" ; OFS="\t" ; print "User\tGID\tUser Name\tHome Dir\t" { print $1 , $3 , $5 , $6 } END { print "\n End of Report \n" } $> user_report /etc/passwd the output of... (5 Replies)
Discussion started by: ghazi
5 Replies

2. Shell Programming and Scripting

sed or awk to convert text files with recurring headings to rows and colum

I have many text file reports generated by a Information Assurance tool that I need to get into a .CSV format or Excel tab delimited format. I want to use sed or awk to grab all the information in the sample text file below and create column headings:Risk ID, Risk Level, Category, Description, How... (5 Replies)
Discussion started by: Bjoeboo
5 Replies

3. UNIX for Dummies Questions & Answers

ls -l column headings

I'm trying to see if there's a way to see column headings when I type the ls -l command. I know what some of the fields mean for example in the following listing: total 136 drwxr-xr-x 2 root root 4096 Jun 5 15:16 bin drwxr-xr-x 3 root root 4096 Jul 9 15:25 boot drwxr-xr-x 9... (6 Replies)
Discussion started by: thoughts
6 Replies

4. AIX

split a filename and print to 2 different headings

I need help to split a filename 'a0crk_user:A0-B0123$#%test' into a0crk_user and A0-B0123 and print the output under 2 different columns namely User and Status. for eg. the output should like below: User Status ---- ------ a0crk_user A0-B0123 (3 Replies)
Discussion started by: mbak
3 Replies

5. Shell Programming and Scripting

Using sed (or similar) to rename variable headings

Hello, I'm rather new to the world of regular expressions and sed, though am excited by its possibilities. I have a particular task I'd like to achieve, and have googled the topic quite a bit. However, having found some codes that perform a task very similar to what I'd like to do, I can't for... (2 Replies)
Discussion started by: redseventyseven
2 Replies

6. Shell Programming and Scripting

help in awk report

home directory = /export/home/jenovaux/ /log Contain 3 file /filename1.log /filename2.log /filename3.log each file from this file is a log for job each file contain success or failed I want to make awk report as the following:- LOGFILENAME ... (1 Reply)
Discussion started by: jenovaux
1 Replies

7. Shell Programming and Scripting

awk command in script gives error while same awk command at prompt runs fine: Why?

Hello all, Here is what my bash script does: sums number columns, saves the tot in new column, outputs if tot >= threshold val: > cat getnon0file.sh #!/bin/bash this="getnon0file.sh" USAGE=$this" InFile="xyz.38" Min="0.05" # awk '{sum=0; for(n=2; n<=NF; n++){sum+=$n};... (4 Replies)
Discussion started by: catalys
4 Replies

8. UNIX for Dummies Questions & Answers

Help needed with adding column headings in syslog report

Hi all, I need your help in adding column headings in the below report. The headings I want are: Count - Host - Message Type The command used to create the report is as follows: for messages in `cat syslog_message_list.txt` do grep $messages syslog.`date +%d%m%y`.log | awk '{print $4 " " "... (4 Replies)
Discussion started by: wthomas
4 Replies

9. UNIX for Dummies Questions & Answers

sort by keeping the headings intact?

Hi all, I have a file with 3 columns separated by space. Each column has a heading. I want to sort according to the values in the 2nd column (ascending order). Ex. Name rank direction goory 0.05 --+ laby 0.0006 --- namy 0.31 -+- ....etc. Output should be Name rank direction laby... (3 Replies)
Discussion started by: Unilearn
3 Replies

10. Shell Programming and Scripting

Remove the headings

HI I am executing faloowing commands. mr batch_1 > my_temp.txt ; mr batch_2 >>my_temp.txt; mr batch_3 >> my_temp.txt; mr batch_4 >> my_temp.txt; and the out put file is as this cat my_temp.txt Machine Name Max Load Current Load Factor O/S Status... (3 Replies)
Discussion started by: ptappeta
3 Replies
Ace::Sequence::Multi(3pm)				User Contributed Perl Documentation				 Ace::Sequence::Multi(3pm)

NAME
Ace::Sequence::Multi - Combine Feature Tables from Multiple Databases SYNOPSIS
use Ace::Sequence::Multi; # open reference database $ref = Ace->connect(-host=>'stein.cshl.org',-port=>200009); # open some secondary databases $db1 = Ace->connect(-host=>'stein.cshl.org',-port=>200010); $db2 = Ace->connect(-path=>'/usr/local/acedb/mydata'); # Make an Ace::Sequence::Multi object $seq = Ace::Sequence::Multi->new(-name => 'CHROMOSOME_I, -db => $ref, -offset => 3_000_000, -length => 1_000_000); # add the secondary databases $seq->add_secondary($db1,$db2); # get all the homologies (a list of Ace::Sequence::Feature objs) @homol = $seq->features('Similarity'); # Get information about the first one -- goes to the correct db $feature = $homol[0]; $type = $feature->type; $subtype = $feature->subtype; $start = $feature->start; $end = $feature->end; $score = $feature->score; # Follow the target $target = $feature->info; # print the target's start and end positions print $target->start,'-',$target->end, " "; DESCRIPTION
Ace::Sequence::Multi transparently combines information stored about a sequence in a reference database with features tables from any number of annotation databases. The resulting object can be used just like an Ace::Sequence object, except that the features remember their database of origin and go back to that database for information. This class will only work properly if the reference database and all annotation databases share the same cosmid map. OBJECT CREATION
You will use the new() method to create new Ace::Sequence::Multi objects. The arguments are identical to the those in the Ace::Sequence parent class, with the addition of an option -secondary argument, which points to one or more secondary databases from which to fetch annotation information. -source The sequence source. This must be an Ace::Object of the "Sequence" class, or be a sequence-like object containing the SMap tag (see below). -offset An offset from the beginning of the source sequence. The retrieved Ace::Sequence will begin at this position. The offset can be any positive or negative integer. Offets are 0-based. -length The length of the sequence to return. Either a positive or negative integer can be specified. If a negative length is given, the returned sequence will be complemented relative to the source sequence. -refseq The sequence to use to establish the coordinate system for the returned sequence. Normally the source sequence is used to establish the coordinate system, but this can be used to override that choice. You can provide either an Ace::Object or just a sequence name for this argument. The source and reference sequences must share a common ancestor, but do not have to be directly related. An attempt to use a disjunct reference sequence, such as one on a different chromosome, will fail. -name As an alternative to using an Ace::Object with the -source argument, you may specify a source sequence using -name and -db. The Ace::Sequence module will use the provided database accessor to fetch a Sequence object with the specified name. new() will return undef is no Sequence by this name is known. -db This argument is required if the source sequence is specified by name rather than by object reference. It must be a previously opened handle to the reference database. -secondary This argument points to one or more previously-opened annotation databases. You may use a scalar if there is only one annotation database. Otherwise, use an array reference. You may add and delete annotation databases after the object is created by using the add_secondary() and delete_secondary() methods. If new() is successful, it will create an Ace::Sequence::Multi object and return it. Otherwise it will return undef and return a descriptive message in Ace->error(). Certain programming errors, such as a failure to provide required arguments, cause a fatal error. OBJECT METHODS
Most methods are inherited from Ace::Sequence. The following additional methods are supported: secondary() @databases = $seq->secondary; Return a list of the secondary databases currently in use, or an empty list if none. add_secondary() $seq->add_secondary($db1,$db2,...) Add one or more secondary databases to the list of annotation databases. Duplicate databases will be silently ignored. delete_secondary() $seq->delete_secondary($db1,$db2,...) Delete one or more secondary databases from the list of annotation databases. Databases not already in use will be silently ignored. SEE ALSO
Ace, Ace::Object, Ace::Sequence,Ace::Sequence::Homol, Ace::Sequence::FeatureList, Ace::Sequence::Feature, GFF AUTHOR
Lincoln Stein <lstein@w3.org> with extensive help from Jean Thierry-Mieg <mieg@kaa.crbm.cnrs-mop.fr> Copyright (c) 1999, Lincoln D. Stein This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See DISCLAIMER.txt for disclaimers of warranty. perl v5.14.2 2001-04-07 Ace::Sequence::Multi(3pm)
All times are GMT -4. The time now is 08:53 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy