Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to display and count

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to display and count
# 8  
Old 02-27-2009
You may try something like this:

Code:
eval "$(mysq -Ne'select concat("count=",count(1),";id=",max(id)) from terminal')"

P.S. The count is 3, why you want to count the column headers?
Last edited by radoulov; 02-27-2009 at 03:00 PM.. Reason: Corrected, see below.
# 9  
Old 02-27-2009
Great job rrk001!
I think I'm not even gonna use two different variables.
I can write my script like this:
Code:
r=$(mysql -e "SELECT id, name FROM terminal WHERE name LIKE '%$v%'" | awk '{count=NR-1;id=$1} END{print count"-"id}')
echo "There are ${r%%-*} results. The last one is ${r##*-}."

I modified count=NR-1 so I don't count the header as a result.

Thanks radoulov as well. I just noticed your post. Working on it.
Last edited by chebarbudo; 02-27-2009 at 11:56 AM.. Reason: forgot to thank radoulov
# 10  
Old 02-27-2009
Hi radoulov,
I like your solution. Eval looks great but there's something wrong with the quoting. I can't make it work.
Code:
supernova:~$ eval "(mysq -Ne'select concat("count=",count(1),";id=",max(id)) from terminal')"
-bash: unexpected EOF while looking for matching `''
-bash: syntax error: unexpected end of file

# 11  
Old 02-27-2009
I got it!
You need to put a dollar sign around the evaluated expression.
Code:
eval $(mysql ndtv -Ne 'select concat("count=",count(1),";id=",max(id)) from terminal')

# 12  
Old 02-27-2009
Quote:
Originally Posted by chebarbudo
I got it!
You need to put a dollar sign around the evaluated expression.
Code:
eval $(mysql ndtv -Ne 'select concat("count=",count(1),";id=",max(id)) from terminal')

Yes, of course, sorry for the typo. I'll correct my post.
# 13  
Old 02-28-2009
Quote:
Originally Posted by chebarbudo
Hi there,
I'd like to find a way to display a string and count the words in it.
Code:
supernova:~# echo 'hello world' | tee - | wc


There's no need for an external command:

Code:
string="hello world"
set -f
set -- $string
printf '%d words in "%s"\n' "$#" "$string"

# 14  
Old 06-17-2009
How to count each word in a text file and display the word along with the count
Hi Johnson,

Can you please modify your word count script "to count each word a file and display the corresponding count for that word".
For example, I have the following data in a text file.
A
B
B
C
D
E
E
E
......etc.
My script output should be
A 1
B 2
C 1
D 1
E 3

Generally my application requires counting the distinct words in a particular column and displaying along with their count.

Thanks in advance...
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to find the count of IP addresses that belong to different subnets and display the count?

Hi, I have a file with a list of bunch of IP addresses from different VLAN's . I am trying to find the list the number of each vlan occurence in the output Here is how my file looks like 1.1.1.1 1.1.1.2 1.1.1.3 1.1.2.1 1.1.2.2 1.1.3.1 1.1.3.2 1.1.3.3 1.1.3.4 So what I am trying... (2 Replies)
Discussion started by: new2prog
2 Replies

2. Shell Programming and Scripting

Count the number of string occurrences to display 0 entries in output

Hello Friends, Can somebody assist an issue I am having? I have a separate file with a list of account ids XXX200B02Y01 XXX200B03Y01 XXX200B05Y01 XXX200B07Y01 XXX200B08Y01 I call the file, and run an egrep against a directory and logfiles AccountID=$(cat... (2 Replies)
Discussion started by: liketheshell
2 Replies

3. Shell Programming and Scripting

Extract count of string in all files and display on date wise

Hi All, hope you all are doing well! I kindly ask you for shell scripting help, here is the description: I have huge number of files shown below on date wise, which contains different strings(numbers you can say) including 505001 and 602001. ... (14 Replies)
Discussion started by: VasuKukkapalli
14 Replies

4. Programming

SQL*PLUS How to display a count of 0

Hi, I have been frantically googling and checking some sqlplus forums, but can't find the correct syntax. Basically within sqlplus I want to do a count on a table and if the count is 0 it displays 0 instead of "no rows found". For eample: select count(*) from tableA where... (3 Replies)
Discussion started by: chris01010
3 Replies

5. Shell Programming and Scripting

To search for a particular tag in xml and collate all similar tag values and display them count

I want to basically do the below thing. Suppose there is a tag called object1. I want to display an output for all similar tag values under heading of Object 1 and the count of the xmls. Please help File: <xml><object1>house</object1><object2>child</object2>... (9 Replies)
Discussion started by: srkmish
9 Replies

6. UNIX for Dummies Questions & Answers

Single UNIX command to display users and to count them

Hello everyone, I am new to Unix and I am stuck with a problem. I need only a single command to display the output of who and then add the total number of users and display at the bottom of that output. Example-: (Expected output) sreyan@debian:~$ <command> sreyan tty7 ... (7 Replies)
Discussion started by: sreyan32
7 Replies

7. Shell Programming and Scripting

Read File and Display The Count of a particular field

Hi Mates, I require help in the following: I have the following file snmp.txt Wed Mar 2 16:02:39 SGT 2011 Class : mmTrapBladeS origin : 10.0.0.0 hostname : 10.0.0.2 msg : IBM Blade Alert: Calendar Index : 10.0.0.2-IBMBLADE Fri Mar 4 07:10:54 SGT 2011 Class : mmTrapBladeS... (2 Replies)
Discussion started by: dbashyam
2 Replies

8. Shell Programming and Scripting

Display the count of files

I am new to shell programming. Can anyone help me out with anyone of these? Display a count of the number of regular files, the number of symbolic links, the number of sub-directories, the number of block-special files, and the number of character-special files in the directory. I don't... (4 Replies)
Discussion started by: wayne1411
4 Replies
Login or Register to Ask a Question