Capture the last record number using "awk" NR variable
Hi Team. I am trying to capture the last record number from a file using the below command ( assuming abc.txt has 21 records and I want 21 as output )
But it is printing all the record number. Can someone please help modify the above command?
If it is a trivial count, then commands like wc can give you this, however I think the easiest way using awk (if you are really doing some processing of the data in awk) is to have a count incremented each time you read a record, then in the END section, display the count.
Would this work for you?:-
Obviously adjust it to your preferences. The above will print a line number for every record read AND the final record count, so this might not be what you want. I would only go with awk if you are doing some other processing. wc is far simpler.
The number of records which is NR contains the current line number. awk has an END{} block, where when it is reached NR will have the number 21 as value in your case.
Anyway, I second what the others say, that the least complex tool needed to do the job might be the tool of choice.
If I got it right, you just want to read an input file and do something with every line.
This could generally also be done with something like this:
...where the echo could be something else of course.
This way you don't even need to know how many lines you have to use it in a for-loop, as it cycles over every line anyway.
Hello, there!
I am trying to pass an awk variable into a shell command in order to collect the result into an awk variable; in Bash it does work, as in:
v='2'; date -d "now + $v weeks"
But in awk it does not, as in:
v="2"
"date -d 'now + v weeks'" | getline newdate
close ("date -d 'now... (3 Replies)
Hi,
I have a snippet like below.
Based on variable i, i wish to print 1,2,3,4,5th columns to Sample files.
For each loop, one column from contetn and results will be pused to sample files. But i have a problem here
i=1
while ; do
`awk -F"\t" '{print $($i)}' $content > Sample_${i}_original`;... (4 Replies)
logs:
"/home/abc/public_html/index.php"
"/home/abc/public_html/index.php"
"/home/xyz/public_html/index.php"
"/home/xyz/public_html/index.php"
"/home/xyz/public_html/index.php"
how to use "cut" or "awk" or "sed" to get the following result:
abc
abc
xyz
xyz
xyz (8 Replies)
Hi,
I have line in input file as below:
3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL
My expected output for line in the file must be :
"1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL"
Can someone... (7 Replies)
hi,
i have a file having datas like that
./a.txt
12344
12345
12346
12347
.....
.....
...
i want to save this datas to another file like that
./b.txt
12344 12345 12346 12347 ... ... ...
i think awk can make this but how? :) waiting for ur help. (3 Replies)
Hi,
Can you tell me how to escape a variable number of slash characters in sed "/" ?
In the script the code looks like this:
cat $file_to_update | sed s/^$param/$param=$tab2*\#\*/1
And the $tab2 value is a path so it will have a number of "/" charracters.
# cat db.cfg | sed... (4 Replies)
Hi Friends,
Can any of you explain me about the below line of code?
mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`
Im not able to understand, what exactly it is doing :confused:
Any help would be useful for me.
Lokesha (4 Replies)
In particular I'm trying to check if a line contains an IP address and then do something with it.
The file contains some lines that have no numbers, some blank lines, and some lines with only IP addresses.
#!/bin/bash
touch file2.txt
cat file1.txt | \
while read line
do
if *.*.*.* ];... (4 Replies)
I have a variable, var="some1|some2|some3"
I want to know how many "|" are in $var.
When I say echo $var | grep -c '|'
I am getting only 1 :confused: :confused: :confused: ? (4 Replies)