elhacker.net cabecera Bienvenido(a), Visitante. Por favor Ingresar o Registrarse
¿Perdiste tu email de activación?.

 

 


Tema destacado: Estamos en la red social de Mastodon


  Mostrar Temas
Páginas: [1]
1  Programación / Scripting / Organizar Archivo Txt con un batch para subirlo a mysql 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
Páginas: [1]
WAP2 - Aviso Legal - Powered by SMF 1.1.21 | SMF © 2006-2008, Simple Machines