I have a data dump in the below format, in which data first 31 rows different data for a particular object(vdisk_name) and then for another
<TBODY> </TBODY>
<TBODY> </TBODY>
I would like to get the data sorted out in the below format
<TBODY>
</TBODY>
and so on
so that mean from the dump I need to sort only above mentioned 8 fields and here I have just mentioned 3 data set but I have to do it for limitless data.
Also each set of data has 31 rows(fields) which is fixed and out of which I want to search 8 fields as mentioned above
Please help me with this and let me know if any more more details required
vdisk_id | 0 |
vdisk_name | E081 |
capacity | 6.44245E+11 |
copy_id | 0 |
status | online |
sync | yes |
primary | yes |
mdisk_grp_id | 0 |
mdisk_grp_name | EVA8K |
type | striped |
mdisk_id | |
mdisk_name | |
fast_write_state | not_empty |
used_capacity | 4.60607E+11 |
real_capacity | 4.73494E+11 |
free_capacity | 12887785472 |
overallocation | 136 |
autoexpand | on |
warning | 80 |
grainsize | 256 |
se_copy | yes |
easy_tier | on |
easy_tier_status | active |
tier | ssd |
tier_capacity | 27380416512 |
tier | enterprise |
tier_capacity | 4.46114E+11 |
tier | nearline |
tier_capacity | 0 |
compressed_copy | no |
uncompressed_used_capacity | 4.60607E+11 |
vdisk_id | 1 |
vdisk_name | EP082 |
capacity | 6.44245E+11 |
copy_id | 0 |
status | online |
sync | yes |
primary | yes |
mdisk_grp_id | 0 |
mdisk_grp_name | EVA8K |
type | striped |
mdisk_id | |
mdisk_name | |
fast_write_state | not_empty |
used_capacity | 5.92415E+11 |
real_capacity | 6.05311E+11 |
free_capacity | 12895649792 |
overallocation | 106 |
autoexpand | on |
warning | 80 |
grainsize | 256 |
se_copy | yes |
easy_tier | on |
easy_tier_status | active |
tier | ssd |
tier_capacity | 22548578304 |
tier | enterprise |
tier_capacity | 5.82762E+11 |
tier | nearline |
tier_capacity | 0 |
compressed_copy | no |
uncompressed_used_capacity | 5.92415E+11 |
vdisk_id | 2.00 |
vdisk_name | EiD010 |
capacity | 1.09951E+12 |
copy_id | 0 |
status | online |
sync | yes |
primary | yes |
mdisk_grp_id | 0 |
mdisk_grp_name | EVA8K |
type | striped |
mdisk_id | |
mdisk_name | |
fast_write_state | not_empty |
used_capacity | 5.87561E+11 |
real_capacity | 6.09552E+11 |
free_capacity | 21990756352 |
overallocation | 180 |
autoexpand | on |
warning | 80 |
grainsize | 256 |
se_copy | yes |
easy_tier | on |
easy_tier_status | active |
tier | ssd |
tier_capacity | 2415919104 |
tier | enterprise |
tier_capacity | 6.07136E+11 |
tier | nearline |
tier_capacity | 0 |
compressed_copy | no |
uncompressed_used_capacity | 5.87561E+11 |
<TBODY> </TBODY>
vdisk_name | EiD010 |
capacity | 1.09951E+12 |
copy_id | 0 |
status | online |
sync | yes |
primary | yes |
mdisk_grp_id | 0 |
mdisk_grp_name | EVA8K |
type | striped |
mdisk_id | |
mdisk_name | |
fast_write_state | not_empty |
used_capacity | 5.87561E+11 |
real_capacity | 6.09552E+11 |
free_capacity | 21990756352 |
overallocation | 180 |
autoexpand | on |
warning | 80 |
grainsize | 256 |
se_copy | yes |
easy_tier | on |
easy_tier_status | active |
tier | ssd |
tier_capacity | 2415919104 |
tier | enterprise |
tier_capacity | 6.07136E+11 |
tier | nearline |
tier_capacity | 0 |
compressed_copy | no |
uncompressed_used_capacity | 5.87561E+11 |
<TBODY> </TBODY>
I would like to get the data sorted out in the below format
vdisk_name |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> </TBODY> | capacity | tier | capacity | tier | capacity | ||||||
E081 |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> |
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> </TBODY> | 27380416512 |
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> </TBODY> |
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> </TBODY> |
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> </TBODY> |
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> </TBODY> | ||||||
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> | active | ssd |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> | enterprise |
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> </TBODY> | nearline | 0 | ||||||
EiD010 | active | ssd |
<TBODY> </TBODY><COLGROUP><COL></COLGROUP> | enterprise |
<COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY> </TBODY> | nearline | 0 |
<TBODY>
</TBODY>
and so on
so that mean from the dump I need to sort only above mentioned 8 fields and here I have just mentioned 3 data set but I have to do it for limitless data.
Also each set of data has 31 rows(fields) which is fixed and out of which I want to search 8 fields as mentioned above
Please help me with this and let me know if any more more details required