How to display and count

chebarbudo · #1 (**permalink**) 02-26-2009

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

Unfortunately, this doesn't work.

Any idea?
Thanks in advance.
Santiago

vgersh99 · #2 (**permalink**) 02-26-2009

'man wc'

Code:

$ echo 'hello world' | wc -w
       2
$ echo 'hello world' | awk '{print NF, $0}'
2

chebarbudo · #3 (**permalink**) 02-26-2009

Thanks vgersh99 for your participation but this doesn't do anything more than my previous tries: It only gives the number of words.

Quote:

Originally Posted by chebarbudo

I'd like to find a way to display a string and count the words in it.

For example:

Code:

supernova:~# magiccommand 'hello world'
hello world
2
supernova:~# magiccommand 'how are you'
how are you
3
supernova:~# magiccommand 'must be something pretty tricky'
must be something pretty tricky
5

Any other idea?
Santiago

vgersh99 · #4 (**permalink**) 02-26-2009

Code:

$ echo 'hello world' | awk '{print $0 ORS NF}'
hello world
2

chebarbudo · #5 (**permalink**) 02-27-2009

Nice job, thanks a lot.

chebarbudo · #6 (**permalink**) 02-27-2009

A bit trikier now.
From the result of a mysql query I actually need to:
1) save the number of rows into one variable ($count)
2) save first field of last line into another variable ($id)
Can you assign variables inside a awk script?

The query:

Code:

santiago:~$ mysql -e 'SELECT id, name FROM terminal'
+----+------------------+
| id | name             |
+----+------------------+
|  3 | John Smith       |
| 18 | Alan Parker      |
| 41 | Bob Johnson      |
+----+------------------+

In that case, $count = 4 and $id = 41.

I could do that by running the query two times but that's what I'd like to avoid.

Code:

santiago:~$ count=$(mysql -e 'SELECT id, name FROM terminal' | wc -l)
santiago:~$ id=$(mysql -e 'SELECT id, name FROM terminal' | tail -1 | cut -f1)

Any advice?
Santiago

rrk001 · #7 (**permalink**) 02-27-2009

Assuming that the output of mysql command would be :

Code:

id	name
3	John Smith
18	Alan Parker
41	Bob Johnson

you can try this.

Code:

result=$(mysql -e 'SELECT id, name FROM terminal' | awk '{count=NR;id=$1} END{print count" "id}')
count=$(echo $result | awk '{print $1}')
id=$(echo $result | awk '{print $2}')

You might have to play around with count=NR;id=$1 if there are formatters/separators in the output.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
count the max by awk	halola85	Shell Programming and Scripting	9	12-01-2008 07:44 AM
replaying a record count with another record count	er_zeeshan05	Shell Programming and Scripting	2	10-30-2008 12:14 AM
Sorting using count, grep and count	sukhpal_78	UNIX for Dummies Questions & Answers	2	06-27-2008 01:13 AM
Display the count of files	wayne1411	Shell Programming and Scripting	4	01-09-2008 10:09 PM
How to count the record count in an EBCDIC file.	oracle8	UNIX for Dummies Questions & Answers	1	07-26-2006 08:22 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: