<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7232.39">
<TITLE>Tokenizing messages</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi Folks,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I'm trying to figure out if there is a way to further parse incoming messages.</FONT>
<BR><FONT SIZE=2 FACE="Arial">Right now I have:</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">destination db_mysql { pipe("/var/log/mysql.pipe" </FONT>
<BR><FONT SIZE=2 FACE="Arial"> template("INSERT INTO logs (host, facility, priority, level, datetime, msg) </FONT>
<BR><FONT SIZE=2 FACE="Arial"> VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$MSG' );\n")</FONT>
<BR><FONT SIZE=2 FACE="Arial"> template-escape(yes)); };</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">But I want to take $MSG and parse it into individual tokens.</FONT>
<BR><FONT SIZE=2 FACE="Arial">How can I accomplish this?</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Tia!</FONT>
<BR><FONT SIZE=2 FACE="Arial">-Clayton</FONT>
</P>
</BODY>
</HTML>