Awk - more than 99 fields?

DaveM · #1 (**permalink**) 01-23-2001

Just written a great little script that analyses a flat ASCII CSV file and reports for any discrepancies with field counts per record etc.

Works fine on all the flat files except one, which has 113 fields per line. AWK can only seemingly cope with up to 99 fields.

Is there any way around this? It will be a pain to check manually as there are more than 100,000 records in this file!

Cheers

Dave

PxT · #2 (**permalink**) 01-23-2001

Probably depends which version of awk you are using. The version distributed with HP-UX supports up to 200
($0 .. $199). You might be able to do some subtraction using $NF if you cant access a field directly.

An alternative would be to use the 'cut' command or, even better, perl.

DaveM · #3 (**permalink**) 01-23-2001

Thanks for that! I eventually used :

cut -d, -f50- input_file > output_file

and then did my awk command on the output file, remembering to subtract 50 from any variable used thereon in.

Thats what I like about UNIX...there is a way around almost anything

Dave

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
combining fields in two text fields	shocker	Shell Programming and Scripting	3	01-16-2008 11:27 AM
cut: get either one or two fields	maxvirrozeito	Shell Programming and Scripting	3	12-17-2007 11:58 AM
Cut Last 3 Fields	bourne	Shell Programming and Scripting	4	01-11-2007 05:17 AM
Last fields	Khoomfire	UNIX for Advanced & Expert Users	3	04-13-2006 06:03 PM
how to cut fields	rajan_ka1	Shell Programming and Scripting	1	12-29-2005 05:55 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