Fix script to get missing information Post: 302927180

Sponsored Content

Top Forums Shell Programming and Scripting Fix script to get missing information Post 302927180 by RudiC on Monday 1st of December 2014 11:20:50 AM

12-01-2014

Registered User

I largely reduced the logics, maybe a bit too far, but it seems to do what you want and gets way more output lines than defined in the sample. Try

Code:

awk     '       {status=substr($0,91,2)
                 ind=substr($0,26,1)
                 split(substr($0, 11, 24-11), val,/\.0 /)
                 key[val[1]val[2]":"ind":"status]++
                 }
         END    {for(i in key)  {split(i, brr, /:/)
                                 if ((brr[3] == 14) || (brr[3] == 98))
                                        print brr[1]" index "brr[2]" has "key[i]" times status " brr[3]
                }
        ' /tmp/input.txt | sort -k1,1n
6936119601 index 1 has 2 times status 98
6936919969 index 2 has 2 times status 14
6937319385 index 1 has 2 times status 98
6937719401 index 1 has 2 times status 98
6937719401 index 2 has 2 times status 98
6937919401 index 2 has 2 times status 14
6937919401 index 3 has 2 times status 14
6938119313 index 1 has 2 times status 98
6938519977 index 1 has 1 times status 14
.
.
.
6960519681 index 1 has 2 times status 98
6960519681 index 2 has 2 times status 98
6960519681 index 3 has 2 times status 98

This User Gave Thanks to RudiC For This Post:

RudiC

View Public Profile for RudiC

Find all posts by RudiC

9 More Discussions You Might Find Interesting

1. Linux

missing in script

Hi , I am trying to make this change work in my script but its not working.The idea is to grep for "CREATE VIEW" and then change view name from orig to VW_orig. but the problem comes when there is no schema prefix to the view name . the code I am using is #!/bin/ksh...

2. Shell Programming and Scripting

fix a problem in this script

z=9 i=0 h=02 min=55 while do cat /home/barmecha/test | grep $h:$min >> /home/barmecha/file1 min=`expr $min + 1` if ; then h=`expr $h + 1` fi i=`expr $i + 1` done i have a log file with time wise log in it, this script help me to pull out logs of the give time interval...but the...

3. Shell Programming and Scripting

how to fix this awk script?

i have a log file while looks like this ++ user_a blabla blabla nas_b blabla user_d this is a user_a junk line another junk line user_c nas_m blabla ++ basically most of the lines contain a "user" keywords, and the rest of the lines do not have "user" at all. So I have the...

4. Shell Programming and Scripting

Fix CSV file with column missing quotes

I have a CSV file that is missing quotes around a column that contains text with commas. Example: Column1, Column2, Column3, Column4, Column5, Column6 Data1, Data2, Data3, Data, 4, Data5, Data6 Data1, Data3, Data3, Data, text, 4, Data5, Data6 I think the easiest way for me to fix this is to...

5. Windows & DOS: Issues & Discussions

Fix script error (%%n)

Hi, I'm currently tinkering with a script that uses the for command to process all *.gif files in the current folder. I marked the spot where it exits out with an error by adding a "pause" The error message given is: convert.exe: unable to open image `%x': No such file or directory @...

6. UNIX for Dummies Questions & Answers

Please help to fix awk script

Good morning, fellows. I would need to ask for your help in editing my awk script. Here is the original version: BEGIN { printf ("CRYST1 200.000 200.000 200.000 90.00 90.00 90.00 P 1 1\n") maxatoms=1000 natom=0 found_struct = 0 found_bond = 0 } { if( NF == 5 ) { foundff=0 natom++...

7. Shell Programming and Scripting

How to fix my IMDB Script

Hello, I am using IMDB bot file for my movie site.. But I get this message like this---Parse error: syntax error, unexpected end of file, expecting variable (T_VARIABLE) or ${ (T_DOLLAR_OPEN_CURLY_BRACES) or {$ (T_CURLY_OPEN) in...

8. Shell Programming and Scripting

My script failed and can't fix it ?

Hi , I'd like to give you a little bit idea about my script which is used to get any generated file from remote server using ftp session then organized those file into directories based on their date ( at the end I supposed to have 1 months directories 20130401 20130402 ....20130430 ,...

9. Shell Programming and Scripting

Missing information in output file

Gents, Using the following code i am able to output the information i need, but some of the strings are not complete due to the separator : used.. Kindly can u help me to get all string after the first : Example in the output file column 16 i should get 17/11/25 03:43:51:732000 but i...

LEARN ABOUT DEBIAN

service

service(8)						      System Manager's Manual							service(8)

NAME

       service - run a System V init script

SYNOPSIS

       service SCRIPT COMMAND [OPTIONS]

       service --status-all

       service --help | -h | --version

DESCRIPTION

       service	runs a System V init script in as predictable an environment as possible, removing most environment variables and with the current
       working directory set to /.

       The SCRIPT parameter specifies a System V init script, located in /etc/init.d/SCRIPT.  The  supported  values  of  COMMAND  depend  on  the
       invoked	script.  service passes COMMAND and OPTIONS to the init script unmodified.  All scripts should support at least the start and stop
       commands.  As a special case, if COMMAND is --full-restart, the script is run twice, first with the stop command, then with the start  com-
       mand.

       service --status-all runs all init scripts, in alphabetical order, with the status command.

EXIT CODES

       service calls the init script and returns the status returned by it.

FILES

       /etc/init.d
	      The directory containing System V init scripts.

ENVIRONMENT

       LANG, TERM
	      The only environment variables passed to the init scripts.

SEE ALSO

       /etc/init.d/skeleton,
       update-rc.d(8),
       init(8),
       invoke-rc.d(8).

								     Jan 2006								service(8)