I have function based out of parameter in file as below
Getheaderline()
{
v_file='ls -lrt | grep -v "^d" | awk '{print $9}'| grep -v "^$"`
export v_file
cd $DATDIR
PCDIR=`pwd`
echo "current directory = "$PCDIR
line1=`sed '1q' $v_file`
v_col1=`echo $line1 | awk -F"," '{print $1}'`
v_col2=`echo $line1 | awk -F"," '{print $2}'`
v_col3=`echo $line1 | awk -F"," '{print $3}'`
}
There is chances the V_col1 , V_col2 , v_col3 would get NUll or funky character(if Excel ftp to unix in ascii mode).
Can anyone suggest what kind of piece of code incorported here to avoid such validation.