How to print last two columns using awk
You can make use of variable NF which is set to the total number of fields in the input record: awk ‘{print $(NF-1),”\t”,$NF}’ file this assumes that you have at least 2 fields.
awk
Is there still any reason to learn AWK?
If you quickly learn the basics of awk, you can indeed do amazing things on the command line. But the real reason to learn awk is to have an excuse to read the superb book The AWK Programming Language by Aho, Kernighan, and Weinberger. The AWK Programming Language at archive.org You would think, from the … Read more
Print all but the first three columns
awk ‘{for(i=1;i<4;i++) $i=””;print}’ file
using awk with column value conditions
If you’re looking for a particular string, put quotes around it: awk ‘$1 == “findtext” {print $3}’ Otherwise, awk will assume it’s a variable name.
How to use multiple arguments for awk with a shebang (i.e. #!)?
The shebang line has never been specified as part of POSIX, SUS, LSB or any other specification. AFAIK, it hasn’t even been properly documented. There is a rough consensus about what it does: take everything between the ! and the \n and exec it. The assumption is that everything between the ! and the \n … Read more
Printing everything except the first field with awk
$1=”” leaves a space as Ben Jackson mentioned, so use a for loop: awk ‘{for (i=2; i<=NF; i++) print $i}’ filename So if your string was “one two three”, the output will be: two three If you want the result in one row, you could do as follows: awk ‘{for (i=2; i<NF; i++) printf $i … Read more
How to escape a single quote inside awk
This maybe what you’re looking for: awk ‘BEGIN {FS=” “;} {printf “‘\”%s’\” “, $1}’ That is, with ‘\” you close the opening ‘, then print a literal ‘ by escaping it and finally open the ‘ again.
Get last field using awk substr
Use the fact that awk splits the lines in fields based on a field separator, that you can define. Hence, defining the field separator to / you can say: awk -F “https://stackoverflow.com/” ‘{print $NF}’ input as NF refers to the number of fields of the current record, printing $NF means printing the last one. So … Read more
sed or awk: delete n lines following a pattern
I’ll have a go at this. To delete 5 lines after a pattern (including the line with the pattern): sed -e ‘/pattern/,+5d’ file.txt To delete 5 lines after a pattern (excluding the line with the pattern): sed -e ‘/pattern/{n;N;N;N;N;d}’ file.txt
How to print matched regex pattern using awk?
This is the very basic awk ‘/pattern/{ print $0 }’ file ask awk to search for pattern using //, then print out the line, which by default is called a record, denoted by $0. At least read up the documentation. If you only want to get print out the matched word. awk ‘{for(i=1;i<=NF;i++){ if($i==”yyy”){print $i} … Read more