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