ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Data parsing question (https://www.excelbanter.com/excel-worksheet-functions/35922-data-parsing-question.html)

Dan Neely

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 ......




All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com