Putting values into order in a field using awk Post: 302721087

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK - printing certain fields when field order changes in data file

I'm hoping someone can help me on this. I have a data file that greatly simplified might look like this: sec;src;dst;proto 421;10.10.10.1;10.10.10.2;tcp 426;10.10.10.3;10.10.10.4;udp 442;10.10.10.5;10.10.10.6;tcp sec;src;fac;dst;proto 521;10.10.10.1;ab;10.10.10.2;tcp...

2. UNIX for Dummies Questions & Answers

Awk search for max and min field values

hi, i have an awk script and I managed to figure out how to search the max value but Im having difficulty in searching for the min field value. BEGIN {FS=","; max=0} NF == 7 {if (max < $6) max = $6;} END { print man, min} where $6 is the column of a field separated by a comma

3. Shell Programming and Scripting

counting lines containing two column field values with awk

Hello everybody, I'm trying to count the number of consecutive lines in a text file which have two distinctive column field values. These lines may appear in several line blocks within the file, but I only want a single block to be counted. This was my first approach to tackle the problem (I'm...

4. Shell Programming and Scripting

AWK: combining consecutive values in a field

Hi, Here is my sample input X 2 AAA Y 3 BBB Y 2 CCC Z 4 DDD In field 1, if the value of one line is same as that of next line, I want to concatenate the corresponding value of the second line in the third field with the value of the third field of first line. And I dont need the third...

5. Shell Programming and Scripting

SED/AWK to edit/add field values in a record

Hi Experts, I am new to shell scripting. Need some help in doing one task given by the customer. The sample record in a file is as follows: 3538,,,,,,ID,ID1,,,,,,,,,,, It needs to be the following: 3538,,353800,353800,,,ID,ID1,,,,,COLX,,,,,COLY, And i want to modify this record in...

6. Shell Programming and Scripting

awk help - matching a field with certail values

Hello there, I have a file with few fields separated by ":". I wrote a below awk to manipulate this file: awk 'BEGIN { FS=OFS=":" }\ NR != 1 && $2 !~ /^98/ && $8 !~ /^6/{print $0}' $in_file > $out_file What I wanted was that if $8 field contains any of the values - 6100, 6110, 6200 -...

7. UNIX for Dummies Questions & Answers

Values with common field in same line with awk

Hi all ! I almost did it but got a small problem. input: cars red cars blue cars green truck black Wanted: cars red-blue-green truck black Attempt: gawk 'BEGIN{FS="\t"}{a = a (a?"-":"")$2; $2=a; print $1 FS $2}' input But I also got the intermediate records...

8. UNIX for Dummies Questions & Answers

Generating all possible combinations of values in field 1 (awk)

Input: A|1 B|2 C|3 D|4 Output: A+B|3 A+C|4 A+D|5 B+C|5 B+D|6 C+D|7 A+B+C|6 A+B+D|7 A+C+D|8 B+C+D|9 A+B+C+D|10 I only managed to get the output for pairs of $1 values (i.e. combination of length 2):

9. Shell Programming and Scripting

Insert field values in a record using awk command

Hi Friends, Below is my input file with "|" (pipe) as filed delimiter: My Input File: HDR|F1|F2||||F6|F7 I want to inser values in the record for field 4 and field 5. Expected output HDR|F1|F2||F4|F5|F6|F7 I am able to append the string to the end of the record, but not in between the...

10. UNIX for Beginners Questions & Answers

awk GSUB read field values from multiple text files

My program run without error. The problem I am having. The program isn't outputting field values with the column headers to file.txt. Each of the column headers in file.txt has no data. MEMSIZE SECOND SASFoundation Filename The output results in file.txt should show: ...

LEARN ABOUT CENTOS

amstatus

AMSTATUS(8)						  System Administration Commands					       AMSTATUS(8)

NAME

       amstatus - display the state of an Amanda run

SYNOPSIS

       amstatus [--file amdumpfile] [--summary] [--dumping] [--waitdumping] [--waittaper] [--dumpingtape] [--writingtape] [--finished] [--failed]
		[--estimate] [--gestimate] [--stats] [--locale-independent-date-format] [--config] config

DESCRIPTION

       Amstatus gives the current state of the Amanda run specified by the config configuration. If there is no active Amanda running, it
       summarizes the result of the last run. It may also be used to summarize the results of a previous run.

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

OPTIONS

       All options may be abbreviated to the shortest non-ambiguous sub-string. If no options are given, everything is displayed.

       [--config] config
	   Specify the Amanda configuration you want to display the state for.

       --file amdumpfile
	   Specify an alternate file instead of the amdump or amflush file.

       --summary
	   Display a summary of the state of the run.

       --dumping
	   Display all partitions that are dumping.

       --waitdumping|wdumping
	   Display all partitions that are waiting to be dumped.

       --waittaper|wtaper
	   Display all partitions dumped that are waiting to be written to tape.

       --dumpingtape|dtape
	   Display all partitions that are dumping directly to tape.

       --writingtape|wtape
	   Display all partitions that are writing to tape.

       --finished
	   Display all partitions that are dumped and written to tape.

       --failed|error
	   Display all partitions that failed.

       --estimate
	   Display all partitions whose estimate is finished. Works only during the estimate phase.

       --gestimate|gettingestimate
	   Display all partitions whose estimate is not finished. Works only during the estimate phase.

       --stats|statistics
	   Display statistics about active-time of taper and dumpers.

       --locale-independent-date-format
	   Output the date in a locale independent format. The format is the same executing: date +'%Y-%m-%d %H:%M:%S %Z'

EXIT CODE

       The exit code of amstatus is the ORed value of:
	0  = success
	1  = error
	4  = a dle failed
	8  = Don't know the status of a dle (RESULT_MISSING in the report)
	16 = tape error or no more tape

SEE ALSO

       amanda(8), amcheck(8), amdump(8), amrestore(8), amadmin(8)

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

AUTHOR

       Stefan G. Weichinger <sgw@amanda.org>

Amanda 3.3.3							    01/10/2013							       AMSTATUS(8)