fullthrottlecb
New Member
- Joined
- Mar 10, 2011
- Messages
- 5
I have a csv file I need to reformat here is my raw data
<table border="0" cellpadding="0" cellspacing="0" width="274"><col style="width: 206pt;" width="274"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 206pt;" width="274" height="20">01099-001-290</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01099-001-289</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01099-001-288</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01126-018-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01126-018-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-007</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-002</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01132-005-007</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01132-005-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-007</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-002</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01149-001-290</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01149-001-289</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01149-001-288</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01155-011-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01155-011-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01155-011-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01155-011-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-007</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-002
<table border="0" cellpadding="0" cellspacing="0" width="274"><col style="width: 206pt;" width="274"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 206pt;" width="274" height="20">01175-017-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-017-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-017-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-017-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-115-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-115-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-115-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-115-006</td> </tr> </tbody></table>
here is what is need
The format of the numbers is always the same.
I need the first five character on a row by itself and then I need the rest in the next column and next rows.
Example is below.
Underscore is to represent a blank cell.
Any help would be appreciated.
Thanks
<table border="0" cellpadding="0" cellspacing="0" width="274"><col style="width: 206pt;" width="274"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 206pt;" width="274" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> </tbody></table><table border="0" cellpadding="0" cellspacing="0" width="274"><tbody></tbody></table></td></tr></tbody></table>
<table border="0" cellpadding="0" cellspacing="0" width="274"><col style="width: 206pt;" width="274"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 206pt;" width="274" height="20">01099-001-290</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01099-001-289</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01099-001-288</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01126-018-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01126-018-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-007</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01129-001-002</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01132-005-007</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01132-005-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-007</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01133-001-002</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01149-001-290</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01149-001-289</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01149-001-288</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01155-011-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01155-011-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01155-011-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01155-011-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-007</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01157-001-002
<table border="0" cellpadding="0" cellspacing="0" width="274"><col style="width: 206pt;" width="274"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 206pt;" width="274" height="20">01175-017-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-017-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-017-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-017-006</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-115-005</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-115-004</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-115-003</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">01175-115-006</td> </tr> </tbody></table>
here is what is need
The format of the numbers is always the same.
I need the first five character on a row by itself and then I need the rest in the next column and next rows.
Example is below.
Underscore is to represent a blank cell.
Any help would be appreciated.
Thanks
<table border="0" cellpadding="0" cellspacing="0" width="274"><col style="width: 206pt;" width="274"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 206pt;" width="274" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">
</td> </tr> </tbody></table><table border="0" cellpadding="0" cellspacing="0" width="274"><tbody></tbody></table></td></tr></tbody></table>
Last edited:
