fullthrottlecb
New Member
- Joined
- Mar 10, 2011
- Messages
- 5
I have a csv file I need to reformat here is my raw data
01099-001-290
01099-001-289
01099-001-288
01126-018-005
01126-018-006
01129-001-007
01129-001-005
01129-001-004
01129-001-003
01129-001-006
01129-001-002
01132-005-007
01132-005-006
01133-001-007
01133-001-005
01133-001-004
01133-001-003
01133-001-006
01133-001-002
01149-001-290
01149-001-289
01149-001-288
01155-011-005
01155-011-004
01155-011-003
01155-011-006
01157-001-007
01157-001-005
01157-001-004
01157-001-003
01157-001-006
01157-001-002
01175-017-005
01175-017-004
01175-017-003
01175-017-006
01175-115-005
01175-115-004
01175-115-003
01175-115-006
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.
___A______________B
1 01099
2__________ 01099-001-290
3 __________01099-001-289
4 __________01099-001-288
5
6 01126
7 __________01126-018-005
8 __________01126-018-006
9 01175
10 _________01175-017-005
11 _________01175-017-004
12 _________01175-017-003
13 _________01175-017-006
14 _________01175-115-005
15 _________01175-115-004
16 _________01175-115-003
17 _________01175-115-006
Any help would be appreciated.
Thanks
01099-001-290
01099-001-289
01099-001-288
01126-018-005
01126-018-006
01129-001-007
01129-001-005
01129-001-004
01129-001-003
01129-001-006
01129-001-002
01132-005-007
01132-005-006
01133-001-007
01133-001-005
01133-001-004
01133-001-003
01133-001-006
01133-001-002
01149-001-290
01149-001-289
01149-001-288
01155-011-005
01155-011-004
01155-011-003
01155-011-006
01157-001-007
01157-001-005
01157-001-004
01157-001-003
01157-001-006
01157-001-002
01175-017-005
01175-017-004
01175-017-003
01175-017-006
01175-115-005
01175-115-004
01175-115-003
01175-115-006
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.
___A______________B
1 01099
2__________ 01099-001-290
3 __________01099-001-289
4 __________01099-001-288
5
6 01126
7 __________01126-018-005
8 __________01126-018-006
9 01175
10 _________01175-017-005
11 _________01175-017-004
12 _________01175-017-003
13 _________01175-017-006
14 _________01175-115-005
15 _________01175-115-004
16 _________01175-115-003
17 _________01175-115-006
Any help would be appreciated.
Thanks