Parse text file to mysql usign cron

I have a text file that dynamically changes every few seconds File name is xyz[today's date].txt Data looks like 15:52:07 Line#9,SIM#1,GSMNumber=+50939900346,SCID=108380 +CUSD: 0,"Pale pou genyen!Votre balance:203,[login to view URL]:2011-02-25 23:59:[login to view URL] nights:412.00 Exp:2010-12-31 .Balances promotionnelles *132#.Compte Fidepwen et tirage:*200#",15 15:52:11 Line#9,SIM#1,GSMNumber=+50939900346,SCID=108380 +CUSD: 0,"Cashback:0,00Exp:2010-12-31 23:59:[login to view URL],[login to view URL]:2011-01-08 23:59:[login to view URL],[login to view URL]:2011-01-27 23:59:59. Min-dimanche:0.0Exp:2010-12-31 23:59:59",15 mysql already has line, sim you need to insert in db time balance Exp1 nights exp2 cashback exp3 bonus exp4 sms exp5 dimanche exp6 15:52 203,00 20100-02-25 412.00 2010-12-31 0,00 2010-12-31 0,00 2011-01-08 0,0 2011-01-27 0.0 2010-12-31 I can define how far back to go in time eg 30 min back means only look at last 30 min of log I can call script from cron parsing must always be done from oldest date to newest date