Mensajes

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

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