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 03:58 PM

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-15-2008
Registered User
 

Join Date: Feb 2008
Posts: 6
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
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 (permalink)  
Old 05-15-2008
Moderator
 

Join Date: Feb 2007
Posts: 1,387
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
Try this:

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

Join Date: Mar 2008
Location: /there/is/only/bin/sh
Posts: 2,252
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
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 (permalink)  
Old 05-16-2008
Registered User
 

Join Date: Feb 2008
Posts: 6
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit! Stumble this Post!Spurl this Post!
Thank you very much.It was a timely help.
Reply With Quote
Google UNIX.COM
Reply

Thread Tools
Display Modes


The 50 most popular UNIX and Linux searches.
Google Search Cloud for The UNIX and Linux Forums
421 service not available, remote server has closed connection ^m automate ftp autosys awk trim bash eval bash for loop boot: cannot open kernel/sparcv9/unix command copy/move folder in unix couldn't set locale correctly curses.h cut command in unix export command in unix find grep find mtime find null character in a unix file grep multiple lines grep or grep recursive inaddr_any inappropriate ioctl for device lynx javascript mailx attachment mget mtime ping port remove first character from string in k shell replace space by comma , perl script rsync ftp scp recursive segmentation fault(coredump) sftp script snoop unix solaris change ip address stale nfs file handle syn_sent tar exclude tar extract to folder test: argument expected unix unix .profile unix forum unix forums unix internals unix interview questions unix mtime unix simulator unix.com vi substitute while loop within while loop shell script


All times are GMT -7. The time now is 02:53 AM.


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

Content Relevant URLs by vBSEO 3.2.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101