AWK line by line instead of field by field?

yongho · #1 (**permalink**) 07-06-2005

I've been using a lot of awk lately for csv files.
But I've been using awk for csv files that contain 32 fields per line.

For the first time, I've been given a csv file that contains one field per line (13 fields in each csv file).

I need to check that a specific field, or line contains a string.
There are no commas or delimiters at the end of each line.

Here's how I would calculate it if all fields were in one line.

Code:

trade_count=`awk -F, '$7 ~ /:22A:NEWT/ { trade_count++ } END { print trade_count }' myCSV.csv`

jim mcnamara · #2 (**permalink**) 07-06-2005

Change $7 to $0 -- $0 is the whole line

yongho · #3 (**permalink**) 07-06-2005

Oh my goodness.

I feel so dumb I'm laughing at myself right now.
That worked so well.......

Thanks.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
need to extract field of characters in a line	jansat	Shell Programming and Scripting	3	05-22-2008 10:44 AM
How to grab the value of field before the line reached	ahjiefreak	Shell Programming and Scripting	3	03-28-2008 05:59 AM
removing last field of the line	adddy	UNIX for Dummies Questions & Answers	4	12-11-2006 11:35 PM
Replacing the last field of a line.	Darek	Shell Programming and Scripting	3	08-19-2005 12:45 PM
Append a field to the end of each line of a file based on searching another file.	ultimate	Shell Programming and Scripting	2	03-29-2005 11:21 AM

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:


	Powered by