Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk problem
Top Forums Shell Programming and Scripting awk problem Post 302893167 by Corona688 on Monday 17th of March 2014 04:21:06 PM
Old 03-17-2014
In situations where you need to 'think back' like this I find it helpful to read the file twice... Once to figure it out, then again to modify and print.

Code:
$ awk -F, -v OFS="," 'NR==FNR { if($2 == 1) L++ ; A[L+0]++; next } # All lines of first file
FNR==1 {L=0} # First line of second file
{ if(A[L]<0) L++; $3=A[L]--; } 1' input input

1,0,5
2,0,4
3,0,3
4,0,2
5,0,1
6,1,0
7,0,5
8,0,4
9,0,3
10,0,2
11,1,1

$

For the first file, it counts up A[L] for each and every line. Every time it finds a 1, it increases L by one too. So A[0] is a count of how many lines were between it and the first one, etc.

The second file it does the exact opposite, counting down. Whenever A[L] goes negative, it increments L one.

It's not bidirectional like yours though yet. You might need to keep two counters and take the minimum.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

AWK Problem

Hi, I posted something here about this yesterday but I can't seem to find it. I needed help writting a script which would append a file with new lines after every so many charachters. Example: (my original flat file) L60 LETTER OF CREDIT 60 DAYS W00 ON RECEIPT WIRE TRANSFER W30 NET... (12 Replies)
Discussion started by: gseyforth
12 Replies

2. Shell Programming and Scripting

Problem with AWK

Hi all, How can i use the below unix command in AWK . Can any one please suggest me how i can use. sed -e "s/which first.sh/which \$0/g" $shell > $shell.sal where $0=current program name(say current.sh) $shell=second.sh (1 Reply)
Discussion started by: krishna_gnv
1 Replies

3. Shell Programming and Scripting

Problem with AWK

Hi All, How can i store a value of the unix command executed in AWK with system command. devise=`cut -c1-3 dvgp.txt` I wrote this command in awk as awk'{ code= sprintf("devise=`cut -c1-3 dvgp.txt`"); system(code); }' Is this correct. can you please suggest me how the code can be... (1 Reply)
Discussion started by: krishna_gnv
1 Replies

4. Shell Programming and Scripting

problem using awk

Hi there every body I'm new to shell scripting and there is a problem facing me,, please look at the following piece of code: awk ' BEGIN{ FS="<assertion id=\1"; RS="<assertion id=\"2"}/<assertion id=\"1/{print FS$2 > "/home/ds2/test/output.txt"} ' filename all I wanna do is to... (6 Replies)
Discussion started by: senior_ahmed
6 Replies

5. Shell Programming and Scripting

Awk problem: How to express the single quote(') by using awk print function

Actually I got a list of file end with *.txt I want to use the same command apply to all the *.txt Thus I try to find out the fastest way to write those same command in a script and then want to let them run automatics. For example: I got the file below: file1.txt file2.txt file3.txt... (4 Replies)
Discussion started by: patrick87
4 Replies

6. Shell Programming and Scripting

Problem with awk awk: program limit exceeded: sprintf buffer size=1020

Hi I have many problems with a script. I have a script that formats a text file but always prints the same error when i try to execute it The code is that: { if (NF==17){ print $0 }else{ fields=NF; all=$0; while... (2 Replies)
Discussion started by: fate
2 Replies

7. Shell Programming and Scripting

awk problem

Find the number of files with sizes > 100KB in /, /bin, /usr, /usr/bin and /usr/sbin directories and output them in a two column format with the name of the directory and the number of files. i tried with awk $>ls -lh | awk '/^-/ && $5 >= 100k {print $8 $5}' but it is not working pls tell... (3 Replies)
Discussion started by: abhikamune
3 Replies

8. UNIX for Dummies Questions & Answers

Little problem with AWK

I thought I had solved this problem but after testing the script I came to realize that it is not doing what I need. So, here it goes again. This is the code: awk '/\>/{F=$2; N=$3; split(FILENAME, A, "."); getline; x = ">"}{print ">" A"-" x++" "F" " N"\n" $0}' This is the input file: ... (5 Replies)
Discussion started by: Xterra
5 Replies

9. Shell Programming and Scripting

awk problem - combining awk statements

i have a datafile that has several lines that look like this: 2,dataflow,Sun Mar 17 16:50:01 2013,1363539001,2990,excelsheet,660,mortar,660,4 using the following command: awk -F, '{$3=strftime("%a %b %d %T %Y,%s",$3)}1' OFS=, $DATAFILE | egrep -v "\-OLDISSUES," | ${AWK} "/${MONTH} ${DAY}... (7 Replies)
Discussion started by: SkySmart
7 Replies

10. Shell Programming and Scripting

awk problem

i have an email list in file.txt with comma separated line1 - FIELD1,pippo@gmail.com,darth@gmail.com line2 - FIELD2,pippo@gmail.com,darth@gmail.com,sampei@gmail.com output=(awk -F ',' -v var="$awkvar" '$1==var {print $2,$3,$4}' spreadsheet.txt)but awk delete some letters at the... (8 Replies)
Discussion started by: pasaico
8 Replies

LEARN ABOUT CENTOS

amplot

AMPLOT(8)						  System Administration Commands						 AMPLOT(8)

NAME

       amplot - visualize the behavior of Amanda

SYNOPSIS

       amplot [-b] [-c] [-e] [-g] [-l] [-p] [-t T] amdump_files

DESCRIPTION

       Amplot reads an amdump output file that Amanda generates each run (e.g.	amdump.1) and translates the information into a picture format
       that may be used to determine how your installation is doing and if any parameters need to be changed.  Amplot also prints out amdump lines
       that it either does not understand or knows to be warning or error lines and a summary of the start, end and total time for each backup
       image.

       Amplot is a shell script that executes an awk program (amplot.awk) to scan the amdump output file. It then executes a gnuplot program
       (amplot.g) to generate the graph. The awk program is written in an enhanced version of awk, such as GNU awk (gawk(1) version 2.15 or later)
       or nawk(1).

       During execution, amplot generates a few temporary files that gnuplot uses. These files are deleted at the end of execution.

       See the amanda(8) man page for more details about Amanda.

OPTIONS

       -b
	   Generate b/w postscript file (need -p).

       -c
	   Compress amdump_files after plotting.

       -e
	   Extend the X (time) axis if needed.

       -g
	   Direct gnuplot output directly to the X11 display (default).

       -p
	   Direct postscript output to file YYYYMMDD.ps (opposite of -g).

       -l
	   Generate landscape oriented output (needs -p).

       -t T
	   Set the right edge of the plot to be T hours.

       The amdump_files may be in various compressed formats (compress, gzip, pact, compact).

INTERPRETATION

       The figure is divided into a number of regions. There are titles on the top that show important statistical information about the
       configuration and from this execution of amdump. In the figure, the X axis is time, with 0 being the moment amdump was started. The Y axis
       is divided into 5 regions:

       QUEUES: How many backups have not been started, how many are waiting on space in the holding disk and how many have been transferred
       successfully to tape.

       %BANDWIDTH: Percentage of allowed network bandwidth in use.

       HOLDING DISK: The higher line depicts space allocated on the holding disk to backups in progress and completed backups waiting to be
       written to tape. The lower line depicts the fraction of the holding disk containing completed backups waiting to be written to tape
       including the file currently being written to tape. The scale is percentage of the holding disk.

       TAPE: Tape drive usage.

       %DUMPERS: Percentage of active dumpers.

       The idle period at the left of the graph is time amdump is asking the machines how much data they are going to dump. This process can take
       a while if hosts are down or it takes them a long time to generate estimates.

BUGS

       Reports lines it does not recognize, mainly error cases but some are legitimate lines the program needs to be taught about.

SEE ALSO

       amanda(8), amdump(8), gnuplot(1), compress(1), gzip(1)

       The Amanda Wiki: : http://wiki.zmanda.com/

AUTHORS

       Olafur Gudmundsson <ogud@tis.com>
	   Trusted Information Systems

       Stefan G. Weichinger <sgw@amanda.org>

Amanda 3.3.3							    01/10/2013								 AMPLOT(8)
All times are GMT -4. The time now is 03:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy