[ksh88 and awk] Number of fields with a value.

ejdv · #1 01-31-2013

Hi,

With:

Code:

# VALUES="one~two~~~"
# echo $VALUES | awk 'BEGIN {FS="~"} {print NF}'
5

PikK45 · #2 01-31-2013

Use FS="~+" instead of FS="~"

ejdv · #3 01-31-2013

Quote:

Originally Posted by PikK45

Use FS="~+" instead of FS="~"

Thanks, but I get the same result:

Code:

# echo $VALUES
one~two~~~
# echo $VALUES | awk 'BEGIN {FS="~"} {print NF}'
5
# echo $VALUES | awk 'BEGIN {FS="~+"} {print NF}'
5

PikK45 · #4 01-31-2013

My results are:

Code:

echo "one~two~~~" | awk -F~ '{print NF}'
5
echo "one~two~~~" | awk -F~+ ' {print NF}'
3

Franklin52 · #5 01-31-2013

Quote:

Originally Posted by ejdv

How to determine the number of fields with a value ?
In this case 2.

Code:

awk -F"~" '{for(i=1;i<=NF;i++){if($i!="")c++}}{print c}' file

PikK45 · #6 01-31-2013

Quote:

Originally Posted by Franklin52

Code:

awk -F"~" '{for(i=1;i<=NF;i++){if($i!="")c++}}{print c}' file

I believe this one is valid to your question

I was in a hurry there

Scrutinizer · #7 01-31-2013

Code:

awk '{print gsub(/[^~]+/,x)}'

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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
awk split lines without knowing the number of fields a-priori	esolvepolito	Shell Programming and Scripting	3	08-22-2012 09:47 AM
How to (n)awk lines of CSV with certain number of fields?	cs03dmj	Shell Programming and Scripting	1	04-07-2010 09:57 AM
Number of fields handled by awk	srivat79	Shell Programming and Scripting	3	09-11-2009 03:16 AM
count number of fields not using SED or AWK	strasner	UNIX for Dummies Questions & Answers	4	07-23-2009 07:44 AM
awk sed cut? to rearrange random number of fields into 3 fields	axo959	Shell Programming and Scripting	4	04-29-2009 04:18 AM