Weekend challenge

[Geoff Canyon]

On Tue, Jul 2, 2013 at 10:28 PM, J. Landman Gay <jacque at hyperactivesw.com>wrote:

> look at a line and store the ID in a variable
> look at that line + 1
>    if the ID is the same, keep going
>    if the ID is different, look at line + 2
>      if line+2 is the old ID, then line+1 is out of order
>      if line+2 is the same as line+1, it's a new block
>        put the new ID into the stored variable
>


The above code is just for the ID, but even on that task it doesn't seem to
do the same thing I did. The above will not flag this as a problem, but my
code would:

ID      SECTION SUBSECTION      TYPE|OP1|OP2
AB      MediumOrchid
AB      MediumOrchid    OrangeRed2
AB      MediumOrchid    Khaki2  DeepPink1|DIV|MULT
AB      MediumOrchid    Gray100 Gray100|MULT|DIV
CD      OliveDrab1
CD      OliveDrab1      Gray47
CD      OliveDrab1      Gray47  Ivory2|PLUS|DIV
CD      OliveDrab1      Azure2  Gray23|MULT|PLUS
AB      MediumOrchid
AB      MediumOrchid    Gray100
AB      Gray40  Gray39  AntiqueWhite4|MULT|MINUS
AB      Gray40  Gray39  Ivory3|MULT|MINUS
AB      Gray40  Gray39  PowderBlue|MINUS|DIV