« Previous Next »

Thread: Can LogParser output one value based on another match value

Last post 10-20-2008 5:02 AM by wlau. 0 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (1 items)

Sort Posts:

  • 10-20-2008, 5:02 AM

    • wlau
    • Not Ranked
    • Joined on 07-31-2008, 5:46 PM
    • Posts 8

    Can LogParser output one value based on another match value

    To all expert,

    Maybe is best to give an example then explanation.

    TranID     Name

    1             ABC

    1

    2             XYZ

    2

    2

    3             ABC

    3

    3

    Need help to output all TranID by giving Name that match, because not all lines have Name value, only the first row in each Transaction has a Name.

    Looking for something like, if Name match my critiria then store TranID as TempValue, then continue to output the rest of the transaction with same TranID based on TempValue, because only the Name is a static value and TranID is a randomly generated value with 23 characters long until the transaction end.

    Then will need to continue the search for the same Name and repeat the process until the end of file.

    The TempValue that I mentioned above is only an assumption, not even sure if there is such ability within LogParser.

    I have been searching the web for answer, and see using pipe from one output of LogParser Select into another LogPaser Select, I don't have enough knowledge here to know if this is something possible either.

    Hope I'm give a clear example, any help is greatly appreciated.

    Regards, - Winson.

     

     

Page 1 of 1 (1 items)
Microsoft Communities