Shell Programming and Scripting

Hi! I need to learn that how a shell script can transverse a csv file n check if any field is empty or not. means its contains two comma or space b/w commas i.e., "" or " ".
can anyone help me out how I can do that....

input.txt:

Code:

a,b,,d,e
1,2, ,4,5
p,q,r,s,t

Code:

$ perl -ne 'print "$_" if (/,,|, ,/)' input.txt
a,b,,d,e
1,2, ,4,5

Is this what you're looking for?

thanks @balajesuri m looking something like dat. i dnt knw much scripting ..but perl i have never used. here m trying to clear my scenario..hope you will understand.

Scenario:
Suppose many *.csv files are in a directory.
Script has to go through all the csv files n check if all the field contains some value. i.e., they are not NULL. like two commas are not coming together. i.e., ",," or ", ,".
then script print the corresponding names on screen which csv files having empty field.

its a bit difficult task for a newbie like me.
thanks

Code:

for x in *.csv; do egrep -q ",,|, ," $x; [ $? -eq 0 ] && echo "$x has an empty field"; done

Code:

grep -l ",[ ]*," *.csv

man grep

HTH
--ahamed

In nawk ..

Code:

$ nawk '$0~/(,,|, ,)/{print FILENAME" NULL FIELDS"|"sort -u"}' *.csv