Null Value


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Null Value
# 1  
Old 04-10-2006
Null Value

Hello All,
I have a file of the format

****
123 abc ABC
456 bcd BCD
789 def
112 ghi GHI
223 jkl
344 mno MNO
****
I am trying to extract the lines that have no values in the third field (in this case, this would be
789 def
223 jkl

Can anyone please help??

Thanks
Khoom
# 2  
Old 04-10-2006
Code:
awk 'NF==2' filename > newfile

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Redirecting standard out to /dev/null goes to file "/dev/null" instead

I apologize if this question has been answered else where or is too elementary. I ran across a KSH script (long unimportant story) that does this: if ; then CAS_SRC_LOG="/var/log/cas_src.log 2>&1" else CAS_SRC_LOG="/dev/null 2>&1" fithen does this: /usr/bin/echo "heartbeat:... (5 Replies)
Discussion started by: jbmorrisonjr
5 Replies

2. Shell Programming and Scripting

NULL checking

Hi I need to check the output of a string to null. For eg the output I get for $KIT is empty. So want to echo something when the output is empty. How can I do that? Thanks in advance (6 Replies)
Discussion started by: Ananthdoss
6 Replies

3. Shell Programming and Scripting

If statement for null

Hi, I want to be able to check if a variable is not equal to null. I am using KSH, and am getting this error message when i run this script: : assignment requires lvalue The line which is causing the problem is as follows: if (($SFTP_DESTINATION != '' ));then if ssh... (6 Replies)
Discussion started by: Jack_Maloney
6 Replies

4. UNIX for Dummies Questions & Answers

/dev/null 2>&1 Versus /dev/null 2>1

How are these two different? They both prevent output and error from being displayed. I don't see the use of the "&" echo "hello" > /dev/null 2>&1 echo "hello" > /dev/null 2>1 (3 Replies)
Discussion started by: glev2005
3 Replies

5. Shell Programming and Scripting

Insert string 'NULL' where there is a null value

I have an input file having 7 fields delimited by , eg : 1,ABC,hg,1,2,34,3 2,hj,YU,2,3,4, 3,JU,kl,4,5,7, 4,JK,KJ,3,56,4,5 The seventh field here in some lines is empty, whereas the other lines there is a value. How do I insert string NULL at this location (7th loc) for these lines where... (8 Replies)
Discussion started by: zilch
8 Replies

6. Shell Programming and Scripting

Checking for null value

Dear All, I'm glad that I've also joined in this forum. Good work fellas... :b: Keep going...! :) I am having a .csv file where I am reading the values with comma(,) as delimiter. After reading each and every values, I would like to check whether it is empty (say null or blank spaces). How... (4 Replies)
Discussion started by: ganapathi.t
4 Replies

7. Shell Programming and Scripting

compare null with non-null

I've got a very peculiar situation. I'm trying to find out if we can compare null fields with non-null. I've output csv files from SQL and Oracle. I need to compare each field from the files, and then find out any differences. The files usualy have over 500 fields, and send the resule to DBA.... (8 Replies)
Discussion started by: nitin
8 Replies

8. Shell Programming and Scripting

Null metacharacter?

Ok, here's what I'm trying to do: I'm trying to formulate an <expression> that will match any of the following: *.jpeg *.jpg *.JPEG *.JPG for a 'find <directory> -name <expression> ' command. I'd like to do *., but don't know what the null character is, or even if it exists. Any... (6 Replies)
Discussion started by: kidcharles
6 Replies

9. UNIX for Dummies Questions & Answers

Null Characters

How do I get rid of null characters/strings in a unix text file. I need to use this in a script. When I use dev/null it puts null characters in my file and makes it larger. Please help (5 Replies)
Discussion started by: alnita
5 Replies

10. UNIX for Advanced & Expert Users

Q1 :/dev/null Q2 -A

Hi, Q1-What does nroff -ms > /dev/null Q2- What does mean -A under STAT column : ps aux |head -20 UTIL PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND root 516 93,0 0,0 12 12 - A 04 nov 3906:51 wait Thank you. (4 Replies)
Discussion started by: big123456
4 Replies
Login or Register to Ask a Question