Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I have to parse the isql logs from sybase. Are there any tools available from Perl? I can use regular expressions but that may not be the most appropriate. It is a fix columns, rather than tab separated fields. Also the field names are defined in first line and field width are define in 2nd line with '-'. Starting from 3rd line are all the values. So it is like
 fieldA fieldB
 --- ---------
The fields and values can extend multiple lines.

Replies are listed 'Best First'.
Re: isql sybase logs
by bichonfrise74 (Vicar) on Sep 17, 2009 at 23:29 UTC
    Do you have a sample data that you can show us?
      Thank you.

      I was looking some standard tool/code at perlmonks etc..
      I made the 'unpack-format' from 2nd line and then used unpack to parse the fields.