View Single Post
  #1   Report Post  
Dan Neely
 
Posts: n/a
Default 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 ......