awk usage in the shell

Brief introduction

Awk is a powerful text analysis tool, with the search for grep and the editing of SED, which is especially powerful when it comes to analyzing data and generating reports. To put it simply, awk reads the file line-by-row, using spaces as the default delimiter to slice each row, and then perform various analytical processing of the cut.

AWK has 3 different versions: AWK, Nawk, and gawk, which are not specifically described, generally referred to as the GNU version of awk, Gawk,gawk.

Awk has its name from the first letter of its founder Alfred Aho, Peter Weinberger and Brian Kernighan's surname. In fact, Awk does have its own language: The awk programming language, a three-bit creator has formally defined it as "style scanning and processing language." It allows you to create short programs that read input files, sort data, manipulate data, perform calculations on input, and generate reports, as well as countless other features.

How to use

awk ' {pattern + action} ' {filenames}

Although the operation can be complex, the syntax is always the same, where pattern represents what AWK looks for in the data, and the action is a series of commands that are executed when a match is found. Curly braces ({}) do not need to always appear in the program, but they are used to group a series of instructions according to a particular pattern. pattern is the regular expression to be represented, surrounded by slashes.

The most basic function of the awk language is to browse and extract information in a file or string based on the specified rules, before awk extracts the information for additional text operations. A complete awk script is typically used to format the information in a text file.

Typically, awk is treated as a unit of a file's behavior. awk processes the text by executing the corresponding command for each line that receives the file.

called awk

There are three ways of calling Awk

1. Command line mode awk [-f field-separator] ' commands ' input-file (s)

Where commands is the true awk command, [-F domain delimiter] is optional. Input-file (s) is the file to be processed.

In awk, each line in a file, separated by a domain delimiter, is called a domain. In general, the default field delimiter is a space without naming the-F domain delimiter. 2.shell Script Mode

Insert all the awk commands into a file and make the awk program executable, and then awk command interpreter as the first line of the script, again by typing the script name to invoke.

Equivalent to the first line of the shell script: #!/bin/sh can be replaced by: #!/bin/awk 3. Insert all awk commands into a separate file, and then call: Awk-f awk-script-file input-file (s)

Where the-f option loads the awk script in Awk-script-file, Input-file (s) is the same as above.

This chapter focuses on the command-line approach.

Getting Started instance

Suppose the output of Last-n 5 is as follows

[[email protected] ~]# last-n 5 <== Remove the first five elements only

Root pts/1 192.168.1.100 Tue Feb 11:21 still logged in root pts/1 192.168.1.100 Tue Feb 10 00:46-02:28 (01:41 )

Root PTS/1 192.168.1.100 Mon Feb 9 11:41-18:30 (06:48)

Dmtsai pts/1 192.168.1.100 Mon Feb 9 11:41-11:41 (00:00)

Root tty1 Fri Sep 5 14:09-14:10 (00:01)

If you only show the 5 most recently logged-in accounts

#last-N 5 | awk ' {print '} '

Root

Root

Root

Dmtsai

Root

The awk workflow is this: reads a record with a ' \ n ' line break, then divides the record by the specified domain delimiter, fills the field, and $ $ represents all fields, representing the first field, $n representing the nth field. The default Domain delimiter is the "blank key" or "[tab] key", so the login user, $ $ means the login user IP, and so on.

If you just show/etc/passwd's account

#cat/etc/passwd |awk-f ': ' {print $} '

Root

Daemon

Bin

Sys

This is an example of awk+action, where each line executes action{print $.

-f Specifies the domain delimiter as ': '.

If you only display the/ETC/PASSWD account and the shell of the account, and the account and the shell are split by tab

#cat/etc/passwd |awk-f ': ' {print $ \ t ' $7} '

Root/bin/bash

Daemon/bin/sh bin/bin/sh sys/bin/sh

If you just show/etc/passwd's account and the shell of the account, and the account is separated by a comma from the shell, and the column name Name,shell is added to all rows, add "Blue,/bin/nosh" to the last line.

CAT/ETC/PASSWD |awk-f ': ' BEGIN {print ' Name,shell '} {print $ ', ' $7} END {print ' Blue,/bin/nosh '} ' Name,shell

Root,/bin/bash

Daemon,/bin/sh bin,/bin/sh sys,/bin/sh ....

Blue,/bin/nosh

The awk workflow is done by first executing the beging, then reading the file, reading a record with the/n line break, and then dividing the record by the specified field delimiter, populating the field, and $ $ representing all fields, representing the first field, $n representing the nth field, The action action corresponding to the execution pattern is then started. Then start reading the second record ... Until all the records have been read, the end operation is performed.

Search all rows with the root keyword/etc/passwd

#awk-F: '/root/'/etc/passwd root:x:0:0:root:/root:/bin/bash

This is an example of the use of pattern, which matches the line of pattern (this is root) to execute the action (without specifying an action, the default output of the contents of each row).

Search support for the regular, for example, root start: awk-f: '/^root/'/etc/passwd

Search all lines that have the root keyword/etc/passwd and display the corresponding shell

# awk-f: '/root/{print $7} '/etc/passwd/bin/bash

Action{print $7} is specified here.

awk built-in variables

Awk has many built-in variables for setting up environment information, which can be changed, and some of the most commonly used variables are given below.

ARGC number of command line arguments

ARGV Command line parameter arrangement

ENVIRON support for the use of system environment variables in queues

FileName awk browses the file name

FNR number of records to browse files

FS sets the input domain delimiter, which is equivalent to the command line-F option

NF browsing the number of fields recorded

NR number of records read

OFS output Field delimiter

ORS Output Record delimiter

RS Control record delimiter

In addition, the $ variable refers to the entire record. $ $ represents the first field of the current row, which is the second field of the current row,...... And so on

Statistics/etc/passwd: File name, line number per line, number of columns per row, corresponding full line contents:

#awk-F ': ' {print ' filename: ' filename ', linenumber: ' NR ', columns: ' NF ', Linecontent: ' $ A} '/etc/passwd Filename:/etc/pa Sswd,linenumber:1,columns:7,linecontent:root:x:0:0:root:/root:/bin/bash

Filename:/etc/passwd,linenumber:2,columns:7,linecontent:daemon:x:1:1:daemon:/usr/sbin:/bin/sh filename:/etc/ Passwd,linenumber:3,columns:7,linecontent:bin:x:2:2:bin:/bin:/bin/sh Filename:/etc/passwd,linenumber:4,columns : 7,linecontent:sys:x:3:3:sys:/dev:/bin/sh

Use printf instead of print to make your code more concise and easy to read

Awk-f ': ' {printf ("filename:%10s,linenumber:%s,columns:%s,linecontent:%s\n", Filename,nr,nf,$0)} '/etc/passwd

Print and the printf

The functions of print and printf two printouts are also available in awk.

The parameters of the print function can be variables, values, or strings. The string must be quoted in double quotation marks, and the arguments are separated by commas. If there are no commas, the parameters are concatenated together and cannot be distinguished. Here, the function of the comma is the same as the delimiter of the output file, except that the latter is a space.

The printf function, whose usage is basically similar to printf in the C language, can format strings, and when the output is complex, printf is more useful and the code more understandable.

awk Programming

variables and Assignments

In addition to Awk's built-in variables, awk can also customize variables.

The following statistics/etc/passwd account number

awk ' {count++;p rint;} End{print "User Count is", count} '/etc/passwd Root:x:0:0:root:/root:/bin/bash

......

User Count is 40

Count is a custom variable. The previous action{} has only one print, in fact print is just a statement, and action{} can have more than one statement, separated by a number.

The count is not initialized here, although the default is 0, but the proper approach is initialized to 0:

awk ' BEGIN {count=0;print ' [Start]user count is ', count} {Count=count+1;print $;} End{print "[End]user Count is], count} '/etc/passwd [Start]user count is 0 root:x:0:0:root:/root:/bin/bash

...

[End]user Count is 40

Count the number of bytes occupied by a file under a folder

Ls-l |awk ' BEGIN {size=0;} {size=size+$5;} End{print "[End]size is", size} '

[End]size is 8657198

If displayed in units of M:

Ls-l |awk ' BEGIN {size=0;} {size=size+$5;} End{print "[End]size is", size/1024/1024, "M"} ' [End]size is 8.25889 M

Note that the statistics do not include subdirectories of folders.

Conditional statements

The conditional statements in awk are drawn from the C language, as described in the following declaration:

if (expression) {

Statement

Statement

... ...

} if (expression) {

Statement

} else {

Statement2;

} if (expression) {

Statement1;

} else if (expression1) {

Statement2;

} else {

Statement3;

}

Count the number of bytes in a file under a folder, filtering files of 4096 size (typically folders):

Ls-l |awk ' BEGIN {size=0;print ' [start]size is ', size} {if ($5!=4096) {size=size+$5;}} End{print "[End]size is", size/1024/1024, "M"} ' [End]size is 8.22339 M

Looping statements

The looping statements in awk also draw on the C language, supporting while, Do/while, for, break, continue, which are semantically identical to the semantics of the C language.

Array

Because the subscript of an array in awk can be numbers and letters, the subscript of an array is often referred to as the keyword (key). The values and keywords are stored inside a table for the Key/value application hash. Since hash is not stored sequentially, it is found in the display of array contents, which are not displayed in the order you expect. Arrays, like variables, are created automatically when they are used, and awk automatically determines whether they store numbers or strings. In general, an array in awk is used to collect information from records, which can be used to calculate sums, count words, and how many times the tracking template is matched.

Show/ETC/PASSWD's account

Awk-f ': ' BEGIN {count=0;} {Name[count] = $1;count++;}; End{for (i = 0; i < NR; i++) print I, Name[i]} '/etc/passwd 0 root 1 daemon 2 bin 3 sys 4 sync 5 games

......

awk usage in the shell