Awk-sed - wc : how to count DOTS "."'s in a file.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Awk-sed - wc : how to count DOTS "."'s in a file.
# 8  
Old 11-06-2013
Thanks, The system is hp-ux 11.23 , I think the grep solution is for gnu grep (for linux system).
However it is good to know.

The awk gsub worked awesome and like it.

Code:
awk '{a+=gsub(/\./,"")}END{print a}' file
241

---------- Post updated at 12:33 AM ---------- Previous update was at 12:32 AM ----------

Finally , Don your solution also worked , and with same result. Thanks a lot.

Code:
$ tr "\n." "x\n" < file | wc -l
241

---------- Post updated at 12:43 AM ---------- Previous update was at 12:33 AM ----------

rdcwayx , Thanks a lot, the awk solution mainly impressed me. I never thought gsub can be used such a way. Brilliant solution.! kudos!.



What I was trying to figure out is time taken, 1 dot , is 5 sec loop: So this is what I got. 20.08 total elapsed time.

Code:
$ awk '{a+=gsub(/\./,"")}END{printf "%.2f Min\n",(a*5)/60}' file
20.08 Min

# 9  
Old 11-06-2013
It processes the input twice, but you could:-
Code:
wc -c file | read allchars filename
tr -d "." < file | wc -c | read nondots
((dots=$allchars-$nondots))

It might be more readable for a future review. It might be a bit slower for very large files because of the double read.



I hope that this helps
Robin
Liverpool/Blackburn
UK
# 10  
Old 11-06-2013
Code:
tr -Cd '.' < file | wc -c

These 2 Users Gave Thanks to CarloM For This Post:
# 11  
Old 11-06-2013
Just trying out different methods in case anyone is interested:

Perl:
Code:
perl -lne 'print $_ =~ tr/\.//' file

Python:
Code:
python -c 'print open("file").read().count(".")'

This User Gave Thanks to Subbeh For This Post:
# 12  
Old 11-06-2013
All of the proposals so far fail if there are other dots in the line, e.g. file name extensions or like. You need to isolate the row of timing dots like e.g.
Code:
awk '{sub(/^[^:]*::/, ""); print match($0, /[^.]/)-1}' file
241

This User Gave Thanks to RudiC For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

2. Shell Programming and Scripting

Awk,sed : change every 2nd field ":" to "|"

Hi Experts, I have a string with colon delimited, want 2nd colon to be changed to a pipe. data: 101:8:43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3: I am trying with sed, but can change only 1 occurance: echo "101:8:43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3:" | sed 's/:/|/2'... (5 Replies)
Discussion started by: rveri
5 Replies

3. Post Here to Contact Site Administrators and Moderators

Suggestion: adding two new groups "sed" and "awk"

Majority of the questions are pertaining file/string parsing w.r.t sed or awk It would be nice to have these two as their own sub category under shell-programming-scripting which can avoid lot of duplicate posts. (1 Reply)
Discussion started by: jville
1 Replies

4. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

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)
Discussion started by: timmywong
8 Replies

5. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

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)
Discussion started by: shis100
7 Replies

6. Shell Programming and Scripting

Simplify Bash Script Using "sed" Or "awk"

Input file: 2 aux003.net3.com error12 6 awn0117.net1.com error13 84 aux008 error14 29 aux001.ha.ux.isd.com error12 209 aux002.vm.ux.isd.com error34 21 alx0027.vm.net2.com error12 227 dux001.net5.com error123 22 us008.dot.net2.com error121 13 us009.net2.com error129Expected Output: 2... (4 Replies)
Discussion started by: sQew
4 Replies

7. Shell Programming and Scripting

Help to change the file with "sed" and "awk"

Hi experts I want your help to change the file format to my wanted version, please give me a hand thanks $cat file install pass make os pass make build kernel failed usb storage pass chane to | *install* | *make os* | *make build kernel* | *usb storage* | | pass | pass... (7 Replies)
Discussion started by: yanglei_fage
7 Replies

8. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies

9. Shell Programming and Scripting

"sed" to check file size & echo " " to destination file

Hi, I've modified the syslogd source to include a thread that will keep track of a timer(or a timer thread). My intention is to check the file size of /var/log/messages in every one minute & if the size is more than 128KB, do a echo " " > /var/log/messages, so that the file size will be set... (7 Replies)
Discussion started by: jockey007
7 Replies

10. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

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)
Discussion started by: Lokesha
4 Replies
Login or Register to Ask a Question