|
Título: Organizar Archivo Txt con un batch para subirlo a mysql Publicado por: jamonk en 26 Junio 2014, 20:31 pm Hola amigos, buenas tardes, soy nuevo en el foro y requiero ayuda.
¿como hago para organizar por registros un txt que me sale asi del origen para poder cargarlo en una BD Mysql ? Date, Time, Pth,ID,Track#,Mold#,Count#,Path,InspRes1,InspRes2,Status,EOData 06/24 /2014,14:50:21.620,Rejt,20482,0892453,000,0892453,0x0043,0x00000000,0x80000000,0 x80002000,EOData 06/24/2014,14:50:22.117,Pass,20482,0892455,032,0892455,0x0041,0x 00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:21.872,Rejt,20482,0892454, 008,0892454,0x0063,0x00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:22.36 7,Pass,20482,0892456,032,0892456,0x0041,0x00000000,0x00000000,0x00000200,EOData 0 6/24/2014,14:50:22.606,Rejt,20482,0892457,000,0892457,0x0043,0x00000004,0x000000 00,0x00000000,EOData 06/24/2014,14:50:23.108,Pass,20482,0892459,032,0892459,0x004 1,0x00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:22.862,Rejt,20482,0892 458,018,0892458,0x0063,0x00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:2 3.357,Pass,20482,0892460,027,0892460,0x0041,0x00000000,0x00000000,0x00000200,EOD ata 06/24/2014,14:50:23.604,Rejt,20482,0892461,019,0892461,0x0063,0x00000000,0x00 000000,0x00000200,EOData 06/24/2014,14:50:23.853,Rejt,20482,0892462,038,0892462,0 x0063,0x00000000,0x00000000,0x00000200,EOData Necesito organizarlo asi: Date, Time, Pth,ID,Track#,Mold#,Count#,Path,InspRes1,InspRes2,Status,EOData 06/24/2014,14:50:21.620,Rejt,20482,0892453,000,0892453,0x0043,0x00000000,0x80000000,0x80002000,EOData 06/24/2014,14:50:22.117,Pass,20482,0892455,032,0892455,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:21.872,Rejt,20482,0892454,008,0892454,0x0063,0x00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:22.367,Pass,20482,0892456,032,0892456,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:22.606,Rejt,20482,0892457,000,0892457,0x0043,0x00000004,0x00000000,0x00000000,EOData 06/24/2014,14:50:23.108,Pass,20482,0892459,032,0892459,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:22.862,Rejt,20482,0892458,018,0892458,0x0063,0x00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:23.357,Pass,20482,0892460,027,0892460,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:23.604,Rejt,20482,0892461,019,0892461,0x0063,0x00000000,0x00000000,0x00000200,EOData 06/24/2014,14:50:23.853,Rejt,20482,0892462,038,0892462,0x0063,0x00000000,0x00000000,0x00000200,EOData Título: Re: Organizar Archivo Txt con un batch para subirlo a mysql Publicado por: jamonk en 27 Junio 2014, 22:24 pm logre ajustar el TXT a este formato, pero aun me falta organilzarlo como dije anteriormente
Date, Time, Pth,ID,Track#,Mold#,Count#,Path,InspRes1,InspRes2,Status,EOData 06/28/2014,13:50:06.675,Pa ss,20482,0330204,005,0330204,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/28/2014,13:50:06.918,Pa ss,20482,0330205,034,0330205,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/28/2014,13:50:07.188,Re jt,20482,0330206,011,0330206,0x0043,0x00000180,0x00000061,0x00000200,EOData 06/28/2014,13:50:07.455,Pa ss,20482,0330207,030,0330207,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/28/2014,13:50:07.711,Pa ss,20482,0330208,014,0330208,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/28/2014,13:50:07.965,Re jt,20482,0330209,000,0330209,0x0043,0x00000000,0x00000000,0x00000100,EOData 06/28/2014,13:50:08.229,Pa ss,20482,0330210,017,0330210,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/28/2014,13:50:08.494,Pa ss,20482,0330211,031,0330211,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/28/2014,13:50:08.750,Pa ss,20482,0330212,027,0330212,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/28/2014,13:50:09.015,Pa ss,20482,0330213,027,0330213,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/28/2014,13:50:09.286,Pa ss,20482,0330214,030,0330214,0x0041,0x00000000,0x00000000,0x00000200,EOData 06/28/2014,13:50:09.537,Pa ss,20482,0330215,034,0330215,0x0041,0x00000000,0x00000000,0x00000200,EOData |