I have these test files generated every day. The CSV file layout is the same every time, what changes is the J count. I can't figure out how to put the right data into the right field and keep adding until all the J values are accounted for.
I have this going into excel but want it in a database so it can be distrubited.
any help with this problem. Thank You
<colgroup><col span="14"></colgroup><tbody>
</tbody>
I have this going into excel but want it in a database so it can be distrubited.
any help with this problem. Thank You
4A1 | |||||||||||||
0x401F | 71 | F | 8302 | 240 | |||||||||
70 | 60 | 70 | 60 | 2.1 | 30 | 0 | 0 | 0 | 1 | 0 | TECH TOM | 0xF48 | |
255 | 255 | NOT SPECIFIED | NOT SPECIFIED | 5/06/2013 | 1:03 PM | 8.07E+08 | 193-723J | 2 | |||||
J1 | 7363 | 2.268 | 0 | 0 | 0 | ||||||||
J2 | 7567 | 2.269 | 0 | 0 | 0 | ||||||||
J3 | 9122 | 2.265 | 0 | 0 | 0 | ||||||||
J4 | 6892 | 2.266 | 0 | 0 | 0 | ||||||||
J5 | 6551 | 2.274 | 0 | 0 | 0 | ||||||||
J6 | 6503 | 2.271 | 0 | 0 | 0 | ||||||||
J7 | 6635 | 2.297 | 0 | 0 | 0 | ||||||||
J8 | 7841 | 2.295 | 0 | 0 | 0 | ||||||||
J9 | 8569 | 2.243 | 0 | 0 | 0 | ||||||||
J10 | 6463 | 2.246 | 0 | 0 | 0 | ||||||||
J11 | 6173 | 2.292 | 0 | 0 | 0 | ||||||||
J12 | 6526 | 2.297 | 0 | 0 | 0 | ||||||||
J13 | 6135 | 2.303 | 0 | 0 | 0 | ||||||||
J14 | 7344 | 2.245 | 0 | 0 | 0 | ||||||||
J15 | 6586 | 2.295 | 0 | 0 | 0 | ||||||||
J16 | 7066 | 2.282 | 0 | 0 | 0 | ||||||||
J17 | 6047 | 2.282 | 0 | 0 | 0 | ||||||||
J18 | 7672 | 2.28 | 0 | 0 | 0 | ||||||||
J19 | 7636 | 2.273 | 0 | 0 | 0 | ||||||||
J20 | 6279 | 2.284 | 0 | 0 | 0 | ||||||||
J21 | 7558 | 2.261 | 0 | 0 | 0 | ||||||||
J22 | 5814 | 2.261 | 0 | 0 | 0 | ||||||||
J23 | 6740 | 2.278 | 0 | 0 | 0 | ||||||||
J24 | 6931 | 2.263 | 0 | 0 | 0 |
<colgroup><col span="14"></colgroup><tbody>
</tbody>