Oops! Found an error... it was not detecting "D M Y"
where "D M Y" are digits. Very sorry. Oh yes,
this code requires two imports "time" and "string".
Kind Regards,
Clark
P.S. This may still have a few latent bugs
but seems pretty stable.
...
### Forgiving Date Handling
### Contributed by Clark C. Evans, (c) 2001, Xgenda, Inc.
### Redistribution and use in source and binary
### forms, with or without modification, are
### permitted without restriction.
s2d = { 'jan':1, 'feb':2, 'mar':3, 'apr':4, 'may':5, 'jun':6,
'jul':7, 'aug':8, 'sep':9, 'oct':10, 'nov':11, 'dec':12,
'january':1, 'febuary':2, 'march':3, 'april':4, 'june':6,
'july':7, 'august':8, 'september':9, 'october':10,
'november':11, 'december':12 }
ldm = {1:31,2:28,3:31,4:30,5:31,6:30,7:31,8:31,9:30,10:31,11:30,12:31
}
d2s = { 1:'Jan', 2:'Feb', 3:'Mar', 4:'Apr', 5:'May', 6:'Jun',
7:'Jul', 8:'Aug', 9:'Sep', 10:'Oct', 11:'Nov', 12:'Dec' }
styleMySQL = '%Y-%m-%d'
styleOracle = '%d-%b-%Y'
def dateString(val,style = styleMySQL):
if not(val): return None
val = dateTuple(val)
if styleMySQL == style:
return str(val[0]) + "-" + str(val[1]) + "-" + str(val[2])
if styleOracle == style:
return str(val[2]) + "-" + str(d2s[val[1]]) + "-" +
str(val[0])
raise Exception("Unknown Style")
def dateTuple(val):
if not(val): return None
def toNumber(val):
try:
return string.atoi(val)
except:
return None
try:
dy = None
yr = None
mo = None
# regular expressions would be good here...
val = string.replace(string.lower(val),'/',' ')
val = string.replace(val,'-',' ')
val = string.replace(val,',',' ')
val = string.replace(val,'*',' ')
val = string.split(val)
if 3== len(val):
a = toNumber(val[0])
b = toNumber(val[1])
c = toNumber(val[2])
if a > 31:
yr = a
if b: # 1999 6 23
mo = b
dy = c
else: # 1999 Jun 23
mo = s2d[val[1]]
dy = c
elif a > 0:
yr = c
if b: # 6 23 1999
dy = b
mo = a
else: # 23 Jun 1999
dy = a
mo = s2d[val[1]]
else: # Jun 23, 2000
dy = b
yr = c
mo = s2d[val[0]]
elif 2 == len(val):
a = toNumber(val[0])
b = toNumber(val[1])
if a > 31:
yr = a
dy = 1
if b > 0: # 1999 6
mo = b
else: # 1999 Jun
mo = s2d[val[1]]
elif a > 0:
if b > 31: # 6 1999
mo = a
yr = b
dy = 1
elif b > 0: # 6 23
mo = a
dy = b
else: # 23 Jun
dy = a
mo = s2d[val[1]]
else:
if b > 31: # Jun 2001
yr = b
dy = 1
else: # Jun 23
dy = b
mo = s2d[val[0]]
elif 1 == len(val):
a = toNumber(val[0])
if a > 31:
dy = 1
mo = 1
yr = a
elif a > 0:
dy = a
else:
mo = s2d[val[0]]
dy = 1
finally:
tm = time.localtime()
if not(yr): yr = tm[0]
if not(mo): mo = tm[1]
if not(dy): dy = tm[2]
if yr < 76: yr = yr + 2000
if yr < 100: yr = yr + 1900
if mo > 12 or mo < 1: mo = 1
if dy < 1: dy = 1
if dy > ldm[mo]:
if 2 == mo:
if not(yr%400) or ( not(yr%4) and yr%100 ): dy = 29
else: dy = 28
else: dy = ldm[mo]
return (yr,mo,dy,0, 0, 0, 0, 0, 0)
_______________________________________________
Webware-discuss mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/webware-discuss
