Log Parser Problem RSS

• • Reply
  

  macnlkc

  1 Post

  Log Parser Problem

  Mar 04, 2013 07:13 PM|LINK

  I have a file that is loosely defined as follow:

  Header Line: LineIdentifier,Data,Data [Only one of these in file]

  Summary Line: SummaryLineIdentifier,Data,Data [File can contain multiple Summary Lines.]

  Detail Line: DetailLineIdentifier,Data,Data [File can contain multiple Detail Lines per Summary Line.]

  FieldLine: FieldLineIndentifer,Data,Data [File can contain multiple Field Lines per Detail Line per Summary Line.]

  There is only one Header line but the file could contain multiple Summary lines that contain multiple Detail Lines that can contain multiple FieldLines.

  An example would be:

  Header,Data,Data

  Summary1,Data,Data

  Detail,Data,Data

  Field,Data,Data

  Summary2,Data,Data,

  Detail,Data,Data

  Summary3,Data,Data,

  Detail,Data,Data

  Field,Data,Data

  Field,Data,Data

  Summary3,Data,Data

  Detail,Data,Data

  Detail,Data,Data

  Field,Data,Data

  Field,Data,Data

  Detail,Data,Data

  Detail,Data,Data

  Field,Data,Data

  Summary4,Data,Data

  Detail,Data

  How would one go about querying this using Logparser?  I need to be able to create a CSV output that would create a hierarchy of this information to be ingested into a database.