The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Google UNIX.COM


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Compare 2 files for a single column and output differences samit_9999 UNIX for Dummies Questions & Answers 1 04-23-2008 09:02 AM
Consecutive spaces within input being converted to single space NinersFan Shell Programming and Scripting 4 09-04-2007 05:59 AM
How can find Null value in If condition koti_rama Shell Programming and Scripting 2 07-17-2007 02:20 AM
replacing single space in argument convenientstore Shell Programming and Scripting 7 04-25-2007 10:02 AM
compare null with non-null nitin Shell Programming and Scripting 8 11-04-2006 04:58 PM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 05-15-2008
Registered User
 

Join Date: Feb 2008
Posts: 6
How to compare null and space using single if condition

Hi

I have a input file with many fields and each filed will be with in double quotes(""). i want to check fields contains balnk,null or space using condition using if. when i write code as below for if condition its not working

a=`awk -F ',' '{gsub("\"", "", $1);'NF==0';printf $1}' temp.txt`
echo $a

if [ -z "$a" ] || ["$a" = " " ]
then
echo "1st filed contains null or space please correct"
else
echo " field has data"
fi

Error message:

Account_SourceFile_Validation.sh[288]: [ : not found.

Can any one help on this.

Thanks
Reply With Quote
Forum Sponsor
  #2  
Old 05-15-2008
Moderator
 

Join Date: Feb 2007
Posts: 2,303
Try this:

Code:
awk -F "," '
{s=$0;gsub(" ", "")}
/""/{print "With blanc field: "s;next}1' temp.txt
Regards
Reply With Quote
  #3  
Old 05-15-2008
era era is offline
Herder of Useless Cats
 

Join Date: Mar 2008
Location: /there/is/only/bin/sh
Posts: 3,650
Or just simply

Code:
egrep '(^|,)" *"(,|$)|^,|,,|,$' temp.txt
If there are fields which contains commas inside the double quotes, you need to elaborate on this (but it's not hideously complex then, either).
Reply With Quote
  #4  
Old 05-16-2008
Registered User
 

Join Date: Feb 2008
Posts: 6
Thank you very much.It was a timely help.
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes




All times are GMT -7. The time now is 07:35 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0