-
Posted to
General Discussion
by
PatrickMc
on
10-29-2009, 6:10 AM
If you ever need to write your own custom log parser (like I did because the management wanted custom reports), here is a good sample custom log parsing script - http://www.biterscripting.com/helppages/SS_WebLogParser.html . It is a good starting point.
Patrick
-
Posted to
Input Formats
by
PatrickMc
on
09-16-2009, 10:24 AM
Consider using the sample script posted at http://www.biterscripting.com/SS_WebLogParser.html . It parse the IIS log. You can modify it to parse your log file to berak each entry into 6 columns.
-
Posted to
Advanced Topics
by
PatrickMc
on
07-27-2009, 5:25 PM
Have you tried writing your own script for parsing logs exactly the way you want ? We often use biterscripting for that. There is a good example script posted at http://www.biterscripting.com/SS_WebLogParser.html to get you started.
Patrick
-
Posted to
Input Formats
by
PatrickMc
on
06-13-2009, 4:35 PM
You can also use biterscripting ( http://www.biterscripting.com ) for CSV files. The $lsep variable describes what separates rows. The $wsep variable describes what separates columns.
For your case ( | and ^)
set $lsep="^"
set $wsep = "|"
# Read file in.
var str data ; cat "file.csv" ...
-
Posted to
Advanced Topics
by
PatrickMc
on
01-11-2009, 1:54 PM
There is a good sample of how to parse web logs at http://www.biterscripting.com/Download/SS_WebLogParser.txt . You can modify it to meet your requirements. I am a system admin and have been using a lot of variants of that script on a daily basis. Works on all Windows versions.
Patrick
-
Posted to
General Discussion
by
PatrickMc
on
01-07-2009, 12:19 PM
This is easy in biterscripting. Use the following commands.
# Read .csv files into a variables.
var str data1, data2, data3
cat "one.csv" >$data1 ; cat "two.csv" >$data2
# Get the number of rows.
var str row1, row2,column2
var int row, rows
set $rows = { len $data1 }
set $row = 1
while ...
-
Posted to
General Discussion
by
PatrickMc
on
12-12-2008, 11:40 AM
The following script will help you get started on biterScripting (.com). It will extract all lines containing the strings "cs-method = POST" and "sc-status = 500". Run the script from biterScripting Interactive. The script will produce a file output.txt which you can then import into Excel or you can modify the script ...