Data parsing question
I've got a set of data in the following format (extra linebreak between rows
to avoid wrapping ambiguities):
Label1:current/max Label3:current/max Label8:current/max
Label1:current/max Labe2:current/max Label11:current/max
Label3:current/max Label4:current/max Label68:current/max
label71:current/max
....
The labels are text strings, possibly with spaces, and in a consistant order
with no space for empty/nonexistant labels. Outside the labels three aren't
any spaces in the tags strings whick are 1/cell. There're upto ~20 triplets
per line, and almost 4000 total lines.
I want to break out into additional columns with the original order
maintained, the lables in every second row of an initial header, current/max
as 2nd row headers below every label and the two values in thier own columns.
Like this (The table's formated for a fixedwiidth font with X's added to
mark empty cells):
Label1 X label2 X Label3 X Lable4 X ......
Cur Max Cur Max Cur Max Cur Max ......
N1 N2 X X N1 N2 X X ......
N1 N2 N1 N2 X X X X ......
X X X X N1 N2 N1 N2 ......
|