recoger datos de un txt Hola tengo un problema y necesito solucionarlo lo mas pronto posible, este archivo se extrae de una aplicación que guarda la información separada por ,"", y necesito capturar todos los datos que se encuentran después de DAY y cada uno almacenarlos en una base de datos
Todas las lineas empiezan por BCMS y las 2 lineas anteriores no me sirven para nada lo que quiro capturar en todas la lineas es esto:
"4/04/12","0","0:00","0","0:00","0:00","0:00","0","0","0 :00","0.0","1"
"Archivo.txt"
4-10-2012 11:15 AM - Data Export
4-10-2012 11:15 AM - Report for Voice System name: UNE - list bcms skill 12 day 04/01
"BCMS SKILL REPORT","EMTELCO","11:32 am TUE APR 10, 2012","Skill:","12","Skill Name:","LAI_OUTSOURCE","20","DAY","4/04/12","0","0:00","0","0:00","0:00","0:00","0","0","0 :00","0.0","1"
"BCMS SKILL REPORT","EMTELCO","11:32 am TUE APR 10, 2012","Skill:","12","Skill Name:","LAI_OUTSOURCE","20","DAY","4/05/12","0","0:00","0","0:00","0:00","0:00","0","0","0 :00","0.0",""
"BCMS SKILL REPORT","EMTELCO","11:32 am TUE APR 10, 2012","Skill:","12","Skill Name:","LAI_OUTSOURCE","20","DAY","4/06/12","0","0:00","0","0:00","0:00","0:00","0","0","0 :00","0.0",""
"BCMS SKILL REPORT","EMTELCO","11:32 am TUE APR 10, 2012","Skill:","12","Skill Name:","LAI_OUTSOURCE","20","DAY","4/07/12","0","0:00","0","0:00","0:00","0:00","0","0","0 :00","0.0",""
"BCMS SKILL REPORT","EMTELCO","11:32 am TUE APR 10, 2012","Skill:","12","Skill Name:","LAI_OUTSOURCE","20","DAY","4/08/12","0","0:00","0","0:00","0:00","0:00","0","0","0 :00","0.0",""
"BCMS SKILL REPORT","EMTELCO","11:32 am TUE APR 10, 2012","Skill:","12","Skill Name:","LAI_OUTSOURCE","20","DAY","4/09/12","0","0:00","0","0:00","0:00","0:00","0","0","0 :00","0.0",""
"BCMS SKILL REPORT","EMTELCO","11:32 am TUE APR 10, 2012","Skill:","12","Skill Name:","LAI_OUTSOURCE","20","DAY","4/10/12","0","0:00","0","0:00","0:00","0:00","0","0","0 :00","0.0",""
"BCMS SKILL REPORT","EMTELCO","11:32 am TUE APR 10, 2012","Skill:","12","Skill Name:","LAI_OUTSOURCE","20","DAY","-----------","-----","-----","----","-----","-----","-------","----","----","-------","-----","---"
"BCMS SKILL REPORT","EMTELCO","11:32 am TUE APR 10, 2012","Skill:","12","Skill Name:","LAI_OUTSOURCE","20","DAY","SUMMARY","0","0 :00","0","0:00","0:00","0:00","0","0","0:00","0.0" ,""
Algun idea por favor ayudanme es un poco urgente y no se como hacerlo.
Gracias |