Shell Programming and Scripting

2011-03-01
2011-03-01
2011-03-01
2011-03-01
2011-03-01
2011-03-02
2011/03/02

for i in `cat test.txt`
do
d=`echo $i | cut -c9-10| sed 's/^0*//'`;
m=`echo $i | cut -c6-7`;
Y=`echo $i | cut -c1-4`;
if cal $m $Y| tr -s " " "|" | tr -s "\n" "|" | grep $d > /dev/null 2>&1;
then 
a=1;
else 
echo "N" ; 
fi
done

while read d
do
    date -d "$d" >/dev/null 2>&1
    [ $? -ne 0 ] && echo $d
done < test.txt

perl -ne 'print "Line #$.: $1\n" if(/(\d+\/\d+\/\d+)/)' test.txt
Line #9: 2011/03/02

$ cat test.txt
2011-03-01
2011-03-01
2011-03-01
2011-03-01
2011-03-01
2011-03-02
2011/03/02
$ (IFS=-;tr "\/" "-" < test.txt | while read d m Y
> do
>    echo "I got \$d=\"$d\", \$m=\"$m\" and \$Y=\"$Y\""
> done)
I got $d="2011", $m="03" and $Y="01"
I got $d="2011", $m="03" and $Y="01"
I got $d="2011", $m="03" and $Y="01"
I got $d="2011", $m="03" and $Y="01"
I got $d="2011", $m="03" and $Y="01"
I got $d="2011", $m="03" and $Y="02"
I got $d="2011", $m="03" and $Y="02"
$

$ (IFS=- ; while read d m Y
> do
>    echo "I got \$d=\"$d\", \$m=\"$m\" and \$Y=\"$Y\""
> done <test.txt)

case $m in
   01) mxd=31 ;;
   02) ((a=($Y%4)/$Y)) 2>/dev/null ;;        # Handles leap year
   03) mxd=31 ;;
   04) mxd=30 ;;
   05) mxd=31 ;;
   06) mxd=30 ;;
   07) mxd=31 ;;
   08) mxd=31 ;;
   09) mxd=30 ;;
   10) mxd=31 ;;
   11) mxd=30 ;;
   12) mxd=31 ;;
   *) echo "Invalid month" ; exit 99
esac

if [ $d -gt $mxd -o $d -lt 1 ]
then
   echo "Invalid day" ; exit 99
fi

grep -v "^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$" test.txt

>>> import time
>>> mask = '%Y-%m-%d'
>>> if time.strptime('2013-12-12', mask):                                                       
...    print "date ok"                                                                          ... 
date ok

#!/usr/bin/python
import time 
def check_mask ( datec,mask='%Y-%m-%d' ):
    try: 
        time.strptime(datec, mask)
    except ValueError:
        return False
    return True

f = open('./test.txt','rb')
for d in f:
   if not check_mask(d.rstrip()):
      print "Invalid: %s" % d,
f.close()

#!/bin/ksh
echo "Basic invalid formatted dates found:-"
grep -v "^[0-9][0-9][0-9][0-9]-[0-1][0-9]-[0-3][0-9]$" test.txt | while read line
do
   echo "\t$line"
done

echo "\nLooking for invalid date values:-"
(IFS=-
typeset -i d m Y mxd L
grep "^[0-9][0-9][0-9][0-9]-[0-1][0-9]-[0-3][0-9]$" test.txt | while read Y m d
do
   case $m in
      1)  mxd=31 ;;
      2)  ((L=($Y%4)/($Y%4))) 2>/dev/null ; ((mxd=29-$L)) ;; # Handles leap year
      3)  mxd=31 ;;
      4)  mxd=30 ;;
      5)  mxd=31 ;;
      6)  mxd=30 ;;
      7)  mxd=31 ;;
      8)  mxd=31 ;;
      9)  mxd=30 ;;
      10) mxd=31 ;;
      11) mxd=30 ;;
      12) mxd=31 ;;
      *)  mxd=0  ;;
   esac

   if [ ${d} -gt ${mxd} -o ${d} -lt 1 ]
   then
      echo "\tInvalid date found \"${Y}-${m}-${d}\""
   fi
done)