Extract portion of data Post: 302650329

Sponsored Content

Top Forums Shell Programming and Scripting Extract portion of data Post 302650329 by superHonda123 on Saturday 2nd of June 2012 11:16:42 AM

06-02-2012

Registered User

Extract portion of data

Hi Gurus,

I need some help in extracting some of these information and massage it into the desired output as shown below.

I need to extract the last row with the header in below sample which is usually the most recent date, for example:
2012-06-01 142356 mb 519 -219406 mb 1 -77049 mb

Notice in the sampe output below, there a new column called: "Label" being added.

FYI, this is just a sample data, the actual data will might contains more data and the listing will be longer.

Sample data:

Code:

Date          New Data #AB       Removed #CD    Net Change
----------  ---------- -----  ---------- -----  ----------
2012-05-27   100046 mb 580    -236329 mb 1      -136282 mb
2012-05-28   117905 mb 628    -223216 mb 1      -105310 mb
2012-05-29   153561 mb 706    -214508 mb 1       -60946 mb
2012-05-30   216141 mb 629    -222977 mb 1        -6835 mb
2012-05-31   180524 mb 468    -221210 mb 1       -40685 mb
2012-06-01   142356 mb 519    -219406 mb 1       -77049 mb
----------  ---------- -----  ---------- -----  ----------
Average      157957 mb        -158746 mb           -789 mb

Top 10 Servers Detected:
------------------------
Total for all servers                  4106890 mb      100.0%
  server1.abc.com	               1298172 mb      31.6%
  server2.abc.com                      708845 mb       17.3%

Sample output:

Code:

Label	     Date        New Data   #AB    Removed    #CD    Net Change
-------	     ----------  ---------- -----  ---------- -----  ----------
Statistic    2012-06-01  142356 mb  519    -219406 mb 1       -77049 mb

Is it possible to generate this kind of output?

Would appreciate for any of you help and advise.

Thank you.

- Jack

superHonda123

View Public Profile for superHonda123

Find all posts by superHonda123

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extract a portion of log file

hello, I want to grep the log file according to time and get the portion of log from one particular time to other. I can grep for individual lines by time but how should I print lines continuously from given start time till end till given end time. Appreciate your ideas, Thanks chandra

2. Shell Programming and Scripting

extract date portion from file

Hi, I have a file where there is a date field (single line variable length file) how to extract just the date portion from it the position of date field may vary anywhere in the line but will always have the format mm-dd-yyyy for eg . xxxxxxxxxxxxxxx09-10-2006xxxxxxxxxxxxxxxxxxxx

3. UNIX for Dummies Questions & Answers

How to extract a portion of text from a log file

I am using Unix on Mac OS X 10.5.6. I am trying to extract the last entry of a log (text) file. As seen below, each log entry looks like the following (date and time change with each log entry): I want the script to extract everything quoted above, including the "===" dividers. ...

4. Shell Programming and Scripting

extract string portion using sed

Hi All I have 3 files as listed below and highlighted in bold the portions of the filenames I need to extract: TOS_TABIN218_20090323.200903231830 TOS_TABIN219_1_20090323.200903231830 TOS_TABIN219_2_20090323.200903231830 I tried source_tabin_name=`echo $fname | sed 's/_.*//'` but I...

5. Shell Programming and Scripting

extract string portion from filename using sed

Hi All, I posted something similar before but I now have a another problem. I have filenames as below TOP_TABIN240_20090323.200903231830 TOP_TABIN235_1_20090323.200903231830 i need to extract the dates as in bold. Using bash v 3.xx Im trying to using the print sed command but...

6. Shell Programming and Scripting

How to extract a text portion from a file

Can some one help me with shell script to extract a text block between two known strings. The given input file is as below: Name: abs Some tesxt.... Some tesxt.... Some tesxt.... end of text Name: xyz Some tesxt.... Some tesxt.... Some tesxt.... end of text Name: efg Some...

7. Shell Programming and Scripting

Removing a portion of data in a file

Hi, I have a folder that contains many (multiple) files 1.fasta 2.fasta 3.fasta 4.fasta 5.fasta . . 100's of files Each such file have data in the following format for example: vi 1.fasta Code: >AB_1 MLKKPIIIGVTGGSGGGKTSVSRAILDSFPNARIAMIQHDSYYKDQSHMSFEERVKTNYDHPLAFDTDFM

8. Shell Programming and Scripting

Extract portion of log info based on specific word

Hi Gurus, I'm using HP-UX B.11.23 operating system. I've been trying to extract a specific wording for example: "A tool used by tp produced warnings" from my below log data, but could not find a way to solve it. My intention is, if the log contain the word: "A tool used by tp produced...

9. Shell Programming and Scripting

How to extract portion of a string?

Hi Gurus, Would like to seek some help on how to extract a portion of string from log's output as shown below. Sample of raw data: piece handle=/test123/disk_dump/test123/df0_cntrl_PCPFCI20120404_68498 tag=TAG20120404T180035 comment=NONE piece...

10. UNIX for Beginners Questions & Answers

Extract a portion of string from each line in Linux

Hi I have to extract the destination path information from each record the file is of variable length so I will not be able to use the print command.The search should start on variable "destinationPath" and it should end at immediate "," also the first field has to be printed Input File:...

LEARN ABOUT CENTOS

rdf2ihx

RDF2BIN(1)							   Debian Manual							RDF2BIN(1)

NAME

       rdf2bin, rdf2com - convert an RDOFF object file to flat binary

SYNOPSIS

       rdf2bin [-o relocation-origin] [-p segment-alignment] [-f format] input-file output-file
       rdf2com [-p segment-alignment] input-file output-file
       rdf2ith [-o relocation-origin] [-p segment-alignment] input-file output-file
       rdf2srec [-o relocation-origin] [-p segment-alignment] input-file output-file

OPTIONS

       -o relocation-origin
	      Relocate	at origin relocation-origin.  If invoked as rdf2com, the default relocation origin will be 0x100. Else, the default origin
	      is 0.

       -p segment-alignment
	      Pad segments until their size is a multiple of segment-alignment.  By default, 16 is used.

       -f format
	      Specify the output format.  The currently supported formats are binary (bin), DOS COM (binary with origin  0x100)  (com)	Intel  hex
	      (ith or ihx), and Motorola S-Records (srec).  If not specified, the format is set by the command name.

AUTHORS

       Julian Hall <jules@earthcorp.com>, H. Peter Anvin <hpa@zytor.com>.

       This manual page was written by Matej Vela <vela@debian.org>.

BUGS

       This utility currently only supports the classic segments .text, .data and .bss.

Debian Project							 September 6, 1999							RDF2BIN(1)