identifying null values in a file

dsravan · #1 (**permalink**) 02-12-2008

I have a huge file with 20 fileds in each record and each field is seperated by "|". If i want to get all the reocrds that have 18th or for that matter any filed as null how can i do it? Please let me know

bobbygsk · #2 (**permalink**) 02-12-2008

To identify the null values on any field

Quote:

grep "||" filename

dsravan · #3 (**permalink**) 02-12-2008

But i want to see if particular field is null or not and not regular nulls in the file

jim mcnamara · #4 (**permalink**) 02-12-2008

Code:

# lets do it for field #18
fld=18
awk -v fld=$fld ' -F'|'  \
   ' { if ($fld=="") { print "Line " $NR " has field " $fld " NULL" }}' myfile

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
How to check Null values in a file column by column if columns are Not NULLs	Mandab	Shell Programming and Scripting	7	03-15-2008 09:57 AM
comparing the null values in the unix	bbc17484	Shell Programming and Scripting	11	02-12-2008 09:36 AM
handling null values in files	ammu	Shell Programming and Scripting	1	11-06-2007 04:43 PM
Null values after emptying a log file	kasie4life	Shell Programming and Scripting	2	10-07-2004 10:36 AM
Identifying and removing control characters in a file.	oracle8	High Level Programming	0	04-13-2004 07:08 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:


	Powered by